unable to set root password

[Palash Mohanlal Kasodhan]

hi everyone,
  i have just installed mysql.i was able to start the mysqld
process.howeveri am unable to set password for root using the following
command sequence :

./bin/mysqladmin -u root -password 'abcd'

I get the following output :
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

I had read that there is a default userid called 'test'.i am unable to use
that as well.

please help me in solving this login problem.

thanks

palash



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Setting the password for root user in mysql

[Palash Mohanlal Kasodhan]

Hi everyone,
I am just starting to work with MySql on MAC OS X.When i
installed mysql i got the following message :

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mysqladmin -u root -h localhost -p password 'new-password'

However, when I try the first command, it gives me the error:

error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) although the mysqld dameon is running.

When i try to execute the 'mysql' client it connects properly with the
server but i am unable to execute any command from the client since I
dont have a valid user id and password combination.

 So please let me know , how to set up a working root account for mysql.



Regards
Palash Kasodhan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php