Setting a password for mysql.

dave`2005 · 05-29-2006, 06:24 AM

Hi all, just started mysql up for the 1st time, i saw this:

Code:

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h Barad-Dur password 'new-password'

The 1st command worked fine but when doing the 2nd one i got:

Code:

/usr/bin/mysqladmin: connect to server at 'Barad-Dur' failed
error: 'Lost connection to MySQL server during query'

Any ideas what im doing wrong? Or is the 1st command sufficient?

Any help appreciated.

willysr · 05-29-2006, 06:42 AM

the first command will try to connect to localhost, your local MySQL Server, and the second one will try to connect to host Barad-Dur, which (i think) not your host, so the first one is sufficient.

Bobocop · 05-29-2006, 07:45 AM

Sorry I posted By Mistake and I can't delete this post now