Questions about MySQL Permissions

Yesterday because the classmate's MySQL database did not know what to do, resulting in the root user can not use the

In particular, the use of root users do not need to enter the password can only see the Infomation_schema table, feel the root authority is missing

But because the machine can't restart, you can't go to MySQL or modify the MySQL password in a way that avoids permissions.

The user table under MySQL is then copied to another library to view permissions

Cp/data/mysql/mysql3306/data/mysql/user.*/data/mysql/mysql3306/data/mysql/hehe/

Chown mysql:mysql/data/mysql/mysql3306/data/mysql/hehe/

And then into the hehe database.

View Permissions Table

Select Host,user from user;

See if you have permission

Questions about MySQL Permissions