Migration to a new Ubuntu 20 server: You are not allowed to create a user with GRANT

SYSTEM INFORMATION
**OS type and version: Ubuntu 20.04.1 LTS
**Webmin version: 1.981
**Virtualmin version: 6.17-3
**Related products version: MySQL version 8.0.27

Hi, I am having a problem with migration to new server from SQL Server version: 5.7.33-0ubuntu0.16.04.1 - (Ubuntu). I get this error when importing wiith:

virtualmin restore-domain --source /root/backups/ --all-domains --all-features
Re-creating mail and FTP users ..
Error: SQL grant all on `eurocity`.* to 'web.eurocity'@'localhost' with grant option failed : You are not allowed to create a user with GRANT
Error
-----
SQL grant all on `eurocity`.* to 'web.eurocity'@'localhost' with grant option failed : You are not allowed to create a user with GRANT
-----

I was reading forum and searching other forums and I just can’t figure it out. I granted all to root on new server, restarted mysql server, moving to mariadb is not a solution for me.

Thanks!

SOLVED.

I removed permissions to databases from users with errors before backing up and add them after restore.

1 Like

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.