Mysql root permission to update error_schema error information

Question

when I try to update one table (GLOBAL_VARIABLES) from information_schema db,

I get an error message:

Access denied for user 'root'@'localhost' to database 'information_schema'

Although I am root with all privileges,

how can i fix the resolution.

or how can i update this table?

thank.

Answer 1

You can change global variables with SET and read them with SHOW.

Learn more about http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html

Answer 2

INFORMATION_SCHEMA "- ", , , , . , , . "". mySQL:

INFORMATION_SCHEMA - , , MySQL. INFORMATION_SCHEMA . , , .

GLOBAL_VARIABLES .