Resetting MySQL root password

b200306 · 02-07-2004, 01:16 PM

Hi!

I have forgotten my MySQL root password. How can I change it?
I am using MySQL 3.23 on RH 9.

Crashed_Again · 02-07-2004, 03:18 PM

I think you have to know the old one to change to a new one. Try:

mysqladmin -u root -p <new_password>

I'm not sure if it will prompt you for the old password though.

b200306 · 02-08-2004, 01:43 PM

I tried that... didn't work.

Is there a way to COMPLETELY remove mysql from the system, including all the databases, config files and passwords?

I tried removing mysql from the RH9 add/remove components menu, but when i reinstalled MySQL, it still asked for my old root password.

Crashed_Again · 02-08-2004, 03:21 PM

Well the mysql passwords are stored in the mysql database so I'd imagine deleting that database would COMPLETLY remove mysql. I'm not sure why RedHat did not delete the database. I'd do this:

rpm -qa | grep mysql

Then remove all the mysql related rpms:

rpm -e mysql mysql-server mysql-client etc.

Then check to see if the mysql database was deleted. It should be in /var/lib/mysql and the database file is called mysql.