[Calisthenics]

Find the path for mysql/bin folder. Run command prompt as administrator:

Code:

> cd path_to_folder\mysql\bin
> mysql -u user -p

Replace `user` with yours and enter the password when it asks for. As soon as you manage to login, execute:

Code:

ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Replace the keywords highlighted with blue color to match yours. After executing the above query, type exit to console twice. In mysql folder, you will find my.ini file. Open it and add

pawn Code:

default_authentication_plugin = mysql_native_password

under [mysqld] block. Restart mysql service and it should work.

Did you install mysql manually or using installer? Or did you install package such as XAAMP or WAMP?