If you get an error message like this:

then the problem is that user can not access the database. This can have several causes:

First of all, you use the correct name and password of your MySQL user for connecting to your database.

Secondly, make sure the your database user has the password and it is not blank. If your database user does not have any password then create a password for your database user by following the steps below.

Start the MySQL server instance or daemon with the --skip-grant-tables option (security setting).

Open your MS-DOS command prompt using “cmd” inside the Run window. Inside it navigate to your MySQL bin folder, such as C:\MySQL\bin using the cd command.

Execute the following command in the command prompt:

Execute the following statements in the command prompt to set the password for root user

Execute below command to flush the changes

If you face the unknown field Password error above then use the below command:

Finally, restart the instance/daemon without the --skip-grant-tables option.

You should now be able to connect with your new password.

Thanks for reading.

Software Professional, I am passionate to work on web/enterprise application. For more information please go to about me. You can follow on Twitter. You can be a friend on Facebook or Google Plus or Linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.