Access denied for user 'root@localhost' (using password:NO)
- by Nasser Hajloo
I'm new to mysql, I'm trying to run Wordpress inmy windows desktop and it need Mysql.
I install everything with Web Platform Installer which provided by microsoft. I never seta root password for mysql and in final step of installing wordpressit askfor root password of mysql.
What is the default password for root (if there is one)
and how to change it?
I try
mysql -u root password '123'
but it show me
Access denied for user 'root@localhost' (using password:NO)
after this I try
mysql -u root -p
but it ask for a password which I don't have
Thank you in advance