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?