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_username>’@‘localhost’ with grant option failed : You are not allowed to create a user with GRANT
I see there was a previous discussion November 2020 but the person was using an older version of MySQL Our old and new server have the same MySQL version. Curious as to how we an resolve this so we can import the websites from the old server to the new.
Any suggestions would be greatly appreciated.