Error Migrating cPanel -> Virtualmin

[calport]

@mlacunza

‘localhost’ with grant option failed

I got rich pickings by using the search facility of the forum. It works just like another that you might have heard of, called Google.

Virtualmin restore fails with mysql error

Operating system: ubuntu OS version: 20.04 issue mentioned here, but not resolved: Restore backup mysql user permissions error when restoring a backup on ubuntu 20.04 with virtualmin restore-domain --source /path/to/backup.tar.gz --all-features --all-domains you get Restore failed : SQL grant all on username.* to ‘ftp@domain’@‘localhost’ with grant option failed : You are not allowed to create a user with GRANT solution mentioned doesn’t solve the problem. this also breaks “transfer serv…

Restore backup MySQL failed

When restoring backup script breaks on importing MySQL database contents with error: Restore failed : SQL grant all on username.* to ‘ftp@domain’@‘localhost’ with grant option failed : You are not allowed to create a user with GRANT I’ve notice it only happens on users which were created for vhost just to connect to database not the main user. Ubuntu 20.04 MySQL 8

Restore backup mysql user permissions error

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 : You are not allowed to create a user with GRANT Please help

Failed to migrate virtual server (CPanel)

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 O…

When importing from CPANEL -- Failed to migrate virtual server

Operating system: Ubuntu OS version: |Description:|Ubuntu 20.04.1 LTS| |Release:|20.04| |Codename:|focal| When Importing from my current VPS hosting CPANEL account, I am getting this error: Failed to migrate virtual server : SQL grant all on pp\_wp.* to ‘pp_wp’@‘localhost’ with grant option failed : You are not allowed to create a user with GRANT The account has email and a Wordpress site.

DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'

I think there is NO mysql admin password in my mysql setup; is it possible to set up a database password in this situation? Given this error, I suspect there is a root password set. But, yes, you can certainly reset the password. From the command line: mysql -u root mysql mysql> SET PASSWORD FOR root@localhost=PASSWORD(‘biglongpassword’); Query OK, 0 rows affected (0.06 sec) If you’ve got a root password, but have forgotten it, you’ll have to first stop/start mysqld with the --skip-grant-t…