MySQL error with local computer access denied for user ' Root ' @ ' localhost ' (using Password:yes)

http://blog.csdn.net/iw1210/article/details/54646093

http://blog.csdn.net/qq_33251859/article/details/58605659

Locate the local MySQL-Installed bin directory:

Click Start-> Run, enter   services.msc
In the Open Service Manager to find MySQL and double-click, will pop out a property box, the "General" tab has an "execution path", from this path you can see its bin directory where.


cmd command into the MySQL bin directory:

MySQL error: The MySQL server is running with the--skip-grant-tables option so it cannot execute this

Solution:mysql> Flush Privilege below details how to give the user authorization.

Mysql> grant permissions 1, permissions 2, ... Permission n on the database name. Table name to User name @ user address identified by ' connection password ';

Permissions 1, Permissions 2, ... Permission N represents 14 permissions for SELECT, INSERT, UPDATE, delete, create, drop, index, alter, Grant, references, reload, shutdown, process, file, and so on.
When permissions 1, permissions 2, ... When permission n is replaced by all privileges or all, the user is given full permission.
When the database name is replaced by *. *, the user is given permission to manipulate all tables on all databases on the server.
The user address can be localhost, or it can be an IP address, a machine name, and a domain name. You can also use '% ' to indicate connections from any address.
' Connection password ' cannot be empty, otherwise the creation failed.

MySQL error with local computer access denied for user ' Root ' @ ' localhost ' (using Password:yes)