MySQL access denied for user ' root ' @ ' localhost ' (using Password:yes)

Solution Solutions

Format: Mysqladmin-u username-P old password password new password

Example: Add a password root to root

First, on the cmd command line, go to the bin directory under the MySQL directory, and type the following command

Mysqladmin-uroot Password root

Note: Because Root does not have a password at the beginning, the-p old password can be omitted.

D:\mysql\bin>mysqladmin-uroot password root password is set to root after return

MySQL access denied for user ' root ' @ ' localhost ' (using Password:yes)