Need Help on MySQL
Well, I got MYSQL loaded on my server, and things are going good. Now, I am trying to follow the documentation of setting the root password by going to the bin directory typing: mysqladmin -u root -p password "my password"
And then it would say Enter password: I do not know how to get through this part, or what the password would be. I tried putting in my password that I was trying to set it to, but that did not work and it printed:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Please help! Thank you! :-)
The command you should be using is:
mysqladmin -u root password "my password"
Notice no "-p". This argument essentially says "prompt me for my password"; however, since the root account doesn't yet have a password, you don't want to try to connect using one.
See here for more detailed instructions.
Ok, I'll do that, thank you!