MySQL Forums

Hi Chris
this is the procedure how to reset the root password

first stop the server
/etc/init.d/mysql stop

second start the mysqld
and it locate depends on how you installed the mysql (rpm or compile)
but it's usually locate in /usr/sbin/
so your command is
/usr/sbin/mysqld --skip-grant-tables

enter mysql
just type
mysql (("with no user")) and that becuase there's no grant tables

mysql> update mysql.user set password = PASSWORD('newpass')
-> where user = 'root';
\q
then stop the mysqld
by issuing this command
mysqladmin shutdown
then start mysql normally
/etc/init.d/mysql start
then u can enter the mysql using the new password

Thanks
Bashar Shannak
CMDBA