root password for mysql

[Ridgerunner]

I can not change the root password for mysql.

This is what I get when I try and change it:

mysql> SET PASSWORD FOR root = pass ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pass' at line 1

Ken

[smfinley]

See the MySQL section of the Notes for the correct syntax.

[Trumar]

Type

mysqladmin -u root password 'thepassword'

where 'thepassword' is the password you want.

Hope that helps :-D

[perplexed]

Alternatively you can grab another mysql database directory e.g. /var/lib/mysql/mysql/ which you do know the root password for and replace it with your current one. I did this without forethought, between a Mysql 3.23 and mysql 4.1 as on fedora 4. It worked... i just didn't mean to copy over and rewrite that database.