MySQL----A description of the Information-schema database-related permissions.

The INFORMATION_SCHEMA database in MySQL is particularly notable for the following points.

1, even a newly created user, that is, this user has only one usage permission. It can view some of the tables in Informatoin_schema.

2. Try to grant the grant select on Information_schema.* to ' testuser ' @ ' localhost '; #这样总是会出错, probably MySQL has a similar setting by default.

3, because by default the user can only see some of the tables in Information_schema, if you want to refer to the user can view all the tables, it is necessary to grant the process permission to the line.

Grant Process on * * to ' testuser ' @ ' localhost ';

For example, cannot execute: SELECT * from innodb_locks; hint: ERROR 1227 (42000): Access denied; You need (at least one's) the PROCESS privilege (s) for this operation

4. MySQL also has a database similar to information_schema it is test. Be careful about the permissions of test.

MySQL----A description of the Information-schema database-related permissions.