changing mySQL password?

[hmueller]

Greetings All,

I am trying to get my new XServe ready to go in service. Not wanting to send it out into the world with no password for MySQL I want to change it but am running into a problem changing the password. I am trying to use this command:

[CODE]mysql -u root -p ‘supersecretpassword'[/CODE]

It then asks me for the current password which is blank, I hit return, when I do I get the following error

[CODE]ERROR 1049: Unknown database ‘supersecretpassword'[/CODE]

Any ideas on what I am doing wrong?

Thanks,
Harry

[Anonymous]

Try:

mysqladmin -u root password 'supersecretpassword'

That’s actually the word “password” in there, followed by your new password in quotes.

Also, check out the MySQL manual page on the topic: http://dev.mysql.com/doc/mysql/en/Default_privileges.html

[Author]

Posts