mysql login
 

I just installed mysql and did a set password for root@localhost...now everytime I issue the msql command from the root prompt I get this:

"ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)"

It worked fine before I did the set password command...How do I "login" using that password?

Try mysql -p or mysql -p databasename. If you want to specify the password on the command line (which I don't recommend) you will need to NOT use any space between the -p and the actual password, like this: mysql -pMyPassword databasename.


Håkan

Hmm I have the same problem :(

That suggestion didn't work for me...