mysql root account password

[Fedora Rocher]

I am trying to install mysql on an older box. I want to try out the XOOPS features on this old distribution. I have this machine running with Fedora 6. When i try to log into my sql buy this command :

mysqladmin -u mysql -p create xoops4

I get a password prompt. But i have not password protected it. How did the password prompt come? Can anyone help me get through it? Thanks in advance...

[Solomon]

Try to login with root by entering this command at console :

mysql -u root -p

If you are prompted for a password then you will need to add a password. Use this command :

mysqladmin -u root password 'enter-pass-here'

Then again try to login as root :

mysql -u root -p

Then enter the new pass and create database and add users...

[Fedora Rocher]

Still on the same problem. I cannot get through mysql :

# mysqladmin -u root -p status
Enter password:
mysqladmin: connect to server
at 'localhost' failed
error: 'Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

[Calvin K]

Go to console and enter the following command :

mysql -u root -p -h localhost

This will get you through... The mysql server takes some assumptions if you do not provide correct parameters.. Hope this works for you..