Current new server is running Ubuntu 20.04.1 LTS with the latest Webmin/Virtualmin Old server is CentOS 7.9 with MySQL 8.0.23 however, when I go to import the backup we receive this message Re-creating MySQL users … Failed to migrate virtual server : SQL grant all on <database>.* to ‘<database_us…

Thank you all for the suggestions. I was able to resolve the issue. See below for my solution. May not be the best but it worked for me. Some Background Regarding this Problem I have a CentOS 6 server running MySQL 5.5. When we tried to migrate using a backup from CPanel it would do the same fail…

I have tried this solution but it did not work [image] Restore backup mysql user permissions error Virtualmin Hi I have problem with restoring vhosts or databases the error: Restore failed : SQL grant all on username.* to ‘ftp@domain’@‘localhost’ with grant option failed…

Try this [image] Virtualmin restore fails with mysql error Virtualmin The only new update I have here is: When I just backup and restore the database, the restore works. When I backup the entire site, the restore fails. Apparently with MySQL 8 you can’t Grant like b…

Thank you for the additional information. I am seeing the database and user. I granted permissions but it seems I cannot Preview Website of a WordPress or Ecommerce website, is that correct? When we Preview Website on any WordPress or OpenCart websites it says “Internal Server Error” Is that norma…

@mattvanderhoff , Personally, call me old school, but I never use the import functionality. I rather do the following. Provision account on new server. Backup website files, databases and email off old server. Upload website to new server (as if it were a new site). Create database on ne…

[image] mattvanderhoff: When we Preview Website on any WordPress or OpenCart websites it says “Internal Server Error” Is that normal since it is a PHP/MySQL website? You should not see the error in preview. This is not normal. Normal is to see the website on a temp url instead of its domain. …

Well done, @mattvanderhoff and thanks for sharing the solution with us

I had issues with my migration from Centos/CPanel/MySQL to Debian/Virtualmin/MariaDB as well. I had to fix a few things: Fix database/user names as they had been imported with a “/” character that needed to be removed… Reset passwords for each as the hashed passwords didn’t come over smoothly. Up…

Hello @dmcortez and welcome to the community. Thanks for your feedback and the workaround for the glitches in the migration from cPanel. What a great debut post this is. :clap:

Hi @calport I did not know you had issues with migration from c panel, how did you fix it? Can you provide some sort of how to or perhaps any other way? As you glorified steps, I cannot see them here or elsewhere. Please share at this time and get something useful back to community so other could be…

Wow you switched from MySQL to MariaDB? That I did not even want to try as I was having issues with my migration. Migrated from CentOS 6/CPanel/MySQL to Ubuntu20.04.1LTS/Virtualmin/MySQL Your fixes are similar to mine minus the “Update the socket MariaDB” Fix database/user name that was created …

Failed to migrate virtual server (CPanel)

Virtualmin

mattvanderhoff February 27, 2021, 2:02pm 2

I have tried this solution but it did not work