[RESOLVED] database password

[cupboy]

How do you set a password for the mysql database? I used to have one, but when I transferred the database to another computer using export and import it has gotten lost, so now there is no password.

Unbelieveably, I cannot figure out how to do it or find any documentation on it either even though this would seem like a common task. I can find where to set a user password. I don't think that's the same thing though.

Can I do it using phpmyadmin somehow? Or is it a SQL command?

[bradgrafelman]

For an example of how to change the root user's password:

SET PASSWORD FOR root@localhost = PASSWORD('passhere');