mysqldump: Couldn't execute 'show events': Access denied for user 'root'@'localhost' to database 'performance_schema' (1044)"

5 posts / 0 new
Last post
#1 Sun, 01/07/2018 - 09:07
Generaal

mysqldump: Couldn't execute 'show events': Access denied for user 'root'@'localhost' to database 'performance_schema' (1044)"

Hello Folks, I have the follow prob, by backing up one of my virtual server, they stopping with the message: mysqldump: Couldn't execute 'show events': Access denied for user 'root'@'localhost' to database 'performance_schema' (1044)" I perform the backup with root log in. And have access to all the 3 Virtual servers.

I have loggin to phpmyadmin and I see for the database "performance_shema" that I have as root, all gants and privileges. By the other Virtual servers, there are no DB performance scheme there. And the backup for these going well.

What can I do to clear this? Delete the DB performances schema? Because they don't exist on the other Virtual servers DB.

Best Regards, Roger

Sun, 01/07/2018 - 09:09
Generaal

Thanks a lot for the great work!

CentOS Linux 7.4.1708 Linux 3.10.0-693.11.1.el7.x86_64 op x86_64

Sun, 01/07/2018 - 11:25
Joe
Joe's picture

I haven't seen this particular error before, but I'm pretty sure this indicates the MySQL root password is wrong in Webmin/Virtuamin. It's not specific to this table, as far as I know, I guess it's just the first table that gets backed up. I'm not really sure...but, the database performance_schema is not specific to one virtual host; it's a database of its own and is used by the MySQL server to maintain some performance metric data so the administrator can monitor performance.

So, go to the Webmin MySQL module and make sure it has the right root password (you should see an error when trying to do anything, if it doesn't). If you don't know the root password for MySQL, you'll need to reset it (I think you can do that in the MySQL module, or you can start it with the skip-grant-tables option, and reset it from the command line).

--

Check out the forum guidelines!

Sun, 01/07/2018 - 17:43
Generaal

Thank you joe for the informatie. When I logged in to pmpMyadmin, with root, I can see the data base and see that the root password has all the right to do everything. But I will looking to your suggestion and see if I can do there some things, to skip this interruption by backup the virtual server. Can it that I place the backup to my backup server, selected the SSH option, with a difference login and password (giving from the host company to make backups)? On the DB performance_schema, there are the user, root and have all the rights to this DB. Best Regards, Roger

CentOS Linux 7.4.1708 Linux 3.10.0-693.11.1.el7.x86_64 op x86_64

Mon, 01/08/2018 - 07:07
Generaal

I try this, but no result: Loggin with root and give this in SQL Window. UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root'; FLUSH PRIVILEGES; GRANT ALL ON . TO 'root'@'localhost'; I think, to save my sever data backup, that I will drop the whole performance_schema database. Best Regards, Roger

CentOS Linux 7.4.1708 Linux 3.10.0-693.11.1.el7.x86_64 op x86_64

Topic locked