Error when migrate VM to new server with different MySQL version (MySQL 8)

You’re migrating a Wordpress site? The easiest way on earth to do that is with the Wordpress migration tool.

You simply install that plugin on your old site. Do a backup with it, download it. Install Wordpress on the new virtual server on your new server, install the plugin there, upload the backup from the other server that you downloaded and you’re done.

I’ve used it at least 50 times and never once had an issue. The only issue you may have is if you have a very large site. I think the default plugin has a limit of 3 GB. If your site is larger than that let me know. I have a version of that plugin that’s old and goes up to 12 GB.