Thank u bathory.
***************************
How to Reset a Forgotten Root Password
MySQL version 3.23.54
Stop MySQL server:
# /etc/init.d/mysqld stop
Start MYSQL with "--skip-grant-tables" option.
# /usr/bin/safe_mysqld --skip-grant-tables
(I must open other new window)
Check status of mysql:
# /etc/init.d/mysqld status
# mysql -u root
mysql> use mysql;
mysql> select user,host,password from user;
mysql> update user set Password = PASSWORD('pass') where User ='root';
Query OK, 2 rows affected (0.02 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> exit
Bye
Stopt and start MySQL:
# /etc/rc.d/init.d/mysqld stop
# /etc/rc.d/init.d/mysqld start
|