MySQL prompted twice for password

So I created a user account for a database entitled “publications” with a password…

e.g. GRANT ALL ON publications.* to ‘myname’@’localhost’ IDENTIFIED BY ‘mypasswd’;

As usual, I type

C:....address of mysql.exe..." -u username

However, it doesn’t work and cmd closes!

I then type

C:....address of mysql.exe..." -u username -p mypassword

And it opens, but I am prompted for yet another password.

I try my best to enter my password which I know is correct, and I am continuously locked out of my account.

I just started MySQL/PHP web programming. Please help! Do I have to reinstall my Wamp Server?

Source: wampserver

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.