Im not sure that this question belongs here, but thisThis is quite doable. XAMPP shluldshould work fine for this. The biggest gotchas will be converting any code that does not use relative addressing to work with a domain and httpsHTTPS.
You can likely get closer to your goal by using tjethe hosts file on your computer to create a domain name (but only have it work on computers with a modified hosts file)
WordpressWordPress is a good tool for web design as its got lots of users and plugins (and uses a mysqlMySQL database for its backendback end) but if the goal is to create a website that directly uses a mysqlMySQL database WordpressWordPress is not a great fit as it largely abstracts the database a way. (I would not write my own CMS or accounting system with it for example. )