I am migrating my dedicated server from whm/cpanel to virtualmin.
After seeing that Grant and User Creation must be in seperate lines in mysql8, I upgraded my mysql5.7 cpanel to mysql8.0 and then I took a backup, thinking that it would properly export a backup with 2 seperate lines; but it exported the same sql lines which cannot be imported into virtualmin, which is Cpanel’s problem not Virtualmin’s. I think they are handling restoration on the air and manipulating those user creation and priviledge grants on the air while restoring, otherwise they also have to have problems…
So, I am trying to find out if there is a better way than manually modifying all the backup files from cpanel per account (specifically mysql.sql file which includes incompatible user/grant lines).
“Re-creating MySQL users …
Failed to migrate virtual server : SQL grant all on mydb\_wp.* to ‘mydb_wp’@‘localhost’ with grant option failed : You are not allowed to create a user with GRANT”
| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Ubuntu 20.04 |
| Virtualmin version | 6.17 |