MySql password not working

heijn@westnet.com.au · 01-24-2006, 05:56 AM

Hi

I have been in the proccess of setting up a server using Fedora Core 3. I have set up MySql and phpMyAdim and set up the pma database using information from a website, very helpful.

I have used the same password for root MySql etc but now cannot get back into MySql as it says the password is incorrect. Is there a file I can go to to fix this problem? I don't feel like reloading Fedora and starting again.
Regards
Luke

bulliver · 01-24-2006, 06:02 AM

Quote:

I have used the same password for root MySql etc

First off, terrible idea. Choose different passwords for everything that needs one. Might seem a bother now, but you will appreciate it when someone roots your box because of a php/MySQL vuln.

Quote:

Is there a file I can go to to fix this problem?

No, but the MySQL documentation will tell you how to change a lost password:
http://dev.mysql.com/doc/refman/5.0/...rmissions.html

Quote:

I don't feel like reloading Fedora and starting again.

Why would you reinstall the OS because of a lost MySQL password? This isn't windows man...

Boby · 01-24-2006, 07:42 AM

I've posted a tutorial on how to recover the MySQL root password, you can find it here.

You can setup at least anothe user will full admin permissions:

Code:

mysql --user=root -p

An then in the MySQL shell:

Code:

GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Hope this helps.
Boby