How do you chage the password in MySQL?

[e980238]

how do you change the password for the root user in MySQL server?

[obitis]

poor water on cpu and watch sparks fly.......
would be prity cool but i wouldnt do that to change a password umm try admin tools, user manager right click on acount click change pass word

[e980238]

uhh,
MySQL server for linux?

[vass0922]

http://www.mysql.com/doc/R/e/Resetting_permissions.html

Here ya go

[qball]

That's if you forgot password. Easier iffin you know password...

To change password, log onto server as user whose password you wish to change. Implies one knows username/password, this is actually a security thingy.

run mysqladmin.
use 'password' command:

password new_password

This can be accomplished through SQL also, using SET command:

SET PASSWORD [FOR user] = PASSWORD("password");