"MySQL Learning" Unknown column ' PASSWORD ' | Access denied for user ' root ' @ ' localhost '

After configuring MySQL to start, log in root user result prompt access denied for user ' root ' @ ' localhost '

Looked up the information, because the root temporary password is empty or wrong password, as if MySQL5.6 after the root default password is not empty so can not log in, anyway, all kinds of strange reasons embarrassing. It took a long time to find a way to deal with.

First use the command mysqld--skip-grant-tables, this command is a function of skipping authentication directly into MySQL, after the input will appear nothing of the situation

At this point, start another cmd with administrator privileges, go to the MySQL bin directory, enter MySQL, and find that you can enter the

Then we try to change the root password, and an error message appears.

Search on the Internet when found that this step can be normal operation, baffled its solution, find out after

The anonymous user cannot change the password, so here we create a new root user, and use the command GRANT all on *. * to ' root ' @ ' localhost ' identified by ' root ' (here to fill in the password) With GRANT option; Note Ending semicolon

Then refresh the permissions list flush privileges;

You can then sign in with the account you just created

"MySQL Learning" Unknown column ' PASSWORD ' | Access denied for user ' root ' @ ' localhost '