Access denied for user 'root@localhost' (using password:NO)

Question

I'm new to MySQL, I'm trying to run WordPress on my Windows desktop and it needs MySQL.

I install everything with Web Platform Installer which is provided by Microsoft. I never set a root password for MySQL and in the final step of installing WordPress, it asks for a MySQL server password.

What is the default password for root (if there is one) and how to change it?

I tried:

mysql -u root password '123'

But it shows me:

Access denied for user 'root@localhost' (using password:NO)

After this I try:

mysql -u root -p

However, it asks for a password which I don't have.

Answer 1

To solve the issue you can reset your root password. One thing you should have in mind that it is not advisable to use root without password.

Are you interested in learning Angularjs from scratch! Have a look at this interesting video on Angularjs provided by Intellipaat: