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