im trying to set up MySQL and PHP to run a message board on my web server.. so far the PHP part is working fine.. my problem is with MySQL..

i try to change the password for the root user of the database and this is what i use and the error i get

/mysqladmin -u -p password 'password'
Enter Password:

mysqladmin: connect to server at 'localhost' failed
error 'access denied for user: 'root@localhost' (Using password: YES)'



i am a noob at both linux and MySQL so i think its me that is doing something wrong.. and since i am a noob you will probably have the spell out the solution..

any help would be great.

Seeing as I never use the mysqladmin method and rather than mess about getting the format wrong I'll tell you another way which has the advantage of changing the password for all login locations and not just the current one

Login to mysql as normal

mysql -u root -p

enter your current password

Once connected to mysql:

use mysql

UPDATE user SET password=PASSWORD('mynewpassword') WHERE user='root';

FLUSH PRIVILEGES;

thank you for your help