MySQL-Set Root access rights

Modify Database Pipe Permissions
The highest-privileged account is root when you first want to control the root link database only with 127.0.0.1来 links.
Use MySQL;
Select User,host from user;
After executing the above two sentences, you will see the root link permission. Delete the superfluous, and leave only 127.0.0.1 on the line.

The delete and set commands are the same as the commands in the previous notes.

And then refresh the permissions
Flush Privileges

Re-Login
Mysql-uroot- h 127.0.0.1 - P

Attention?? To add an-H to specify host

------------------------------------------------------------

MySQL-Set Root access rights