Web Hosting Talk







View Full Version : mySql password lost please help!


greenalien
04-17-2002, 12:46 PM
please help me. I've lost the admin password for mysql. what can I do? Do I have do uninstall and reinstall it? Please help me out of this!! :bawling: :( :bawling:

bacid
04-17-2002, 02:58 PM
mysql.com has instructions on how to restore your lost password..

do a search there

Noldar
04-17-2002, 03:05 PM
You can give this a try.

If the mysql server is running use ps to find the pid and kill it.

Restart the server with the --skip-grant-tables option.

Set the root password with:
mysqladmin -u root password "yournewpassword"

Turn grant tables back on using:
mysqladmin flush-privileges


Richard

greenalien
04-18-2002, 02:24 AM
puuuuh, thanks a lot... it worked. I was really afraid :)