mysql password

[Anon]

Impossible to put a password for root.
i do mysql_install_db
then safe_mysqld &
then cd/usr/bin
then
#mysqladmin -uroot -ppassword'new-password'
then when i do mysql i have this message :
error 1045 :acces denied for user :'root@localhost'(using password :no)

My host+domain =localhost.localdomain.com
Thank you for your help.

[mega_hurtz]

try this

$ mysqladmin -u root -p 'new-password'

[Anon]

When you set up a skeleton mysql system with mysql_install_db, the root account is created without a password.

So, to execute the command to change the password, you don't do this:

#mysqladmin -uroot -ppassword'new-password'

you do this
#mysqladmin -u root password flub2stickle

the root password should now be flub2stickle, and the password will be required for any further use of mysqladmin.

The next step is to forget the password you just entered.

[Anon]

hi i got the same problem but when i try to do what you described i get an error saying :
"unable to change password; error you are using mysql as an anonymous user and anonymous user are not allowed to change passwords"

i am logged in as root, and i run the command from my machine so i assume localhost...

any one got any idea what im doing wrong?

greetz pieter