All geek questions in one place

Flush tables - access denied

I need to return my database, but when I try to reset the tables before backing up, do I get this error? What does the RELOAD privilege mean?

Cannot find RELOAD privilege in phpmyadmin !?

 Error: Access denied; you need the RELOAD privilege for this operation SQL: FLUSH TABLES WITH READ LOCK
+6
source share
2 answers

Perhaps you are not using the FLUSH command using root, but with a limited user.
You need to grant the RELOAD privilege to run the FLUSH .
Look here for MySQL privileges.
So (for example) the root user should use:

 GRANT RELOAD ON *.* TO 'your_user'@'localhost';
+1
source

To clarify:
RELOAD can only be provided globally, not a specific database. Must use *.*

 GRANT RELOAD ON *.* TO 'your_user'@'localhost';

From MySQL docs: GRANT Syntax - Global Privileges

CREATE USER, FILE, PROCESS, RELAX, CLIENT APPLICATIONS, Permissions SLAVE, SHOW DATABASES, SHUTDOWN and SUPER are administrative and can only be provided worldwide.

+15
source

Source: https://habr.com/ru/post/912204/

More articles:


All Articles