Mysql Reset Password

[Poomsag]

I changed root password without password function
now I cannot access database
how to reset root password

[Marc]

Hi,

Code: Select all

[Linux] rc_mySQL stop
[Linux] fork /path/to/safe_mysqld --skip-grant-tables
[Linux] mysql -uroot mysql
mysql> update user set password=PASSWORD('your_new_password') where user='root';
Query OK, 2 rows affected (0.13 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit;
Bye
[Linux] rc_mySQL restart


For mysql-4.1.7a-lightning, the safe_mysqld is replaced by mysqld_safe
So use

Code: Select all

fork /path/to/mysqld_safe --skip-grant-tables


instead of

Code: Select all

fork /path/to/safe_mysqld --skip-grant-tables


in the howto above.
Remark :
with this package : /path/to = /usr/local/mysql/bin (all lower case).

[Poomsag]

Thank you

[Poomsag]

I cannot access mysql by phpmyadmin after assign root password and another user password too.
How to solve this problem.

[giotec]

I cannot access mysql by phpmyadmin after assign root password and another user password too.
How to solve this problem.

Friends!

I am with the same problem.

They can help me?

[dRB]

I cannot access mysql by phpmyadmin after assign root password and another user password too. How to solve this problem.

This link may address the problem:
<a href='http://www.freesco.org/support-forum200607/index.php?showtopic=13630&hl=old+password' target='_blank'>..forum archive</a>

-dRB