Other than mysql.conf, where is mysql password stored?

K

knoxhosting

Verified User
Joined
Jan 10, 2005
Messages
44
Somehow my mysql.conf file got the password removed from it completely (it just says passwd=), and now not even Admin can create new dbs.

How do I got about fixing this?
 
Just a friendly reminder. If you ever change the user in question mysql database (I assume da_admin) the password in setup.txt will be obsolete since that file only stores information during the installation and is never used again except for personal reference ;)
 
Ack! It's still not working!

How would I have changed da_admin's password? or rather, how can I change it to something I know?

I don't remember changing it, but the password recorded in setup.txt is not working and now I can't create dbs.
 
FYI

If you have MySQL 4.1, you need to use an alternate way to change the da_admin password, because DA is not yet compatible with it...

mysql>SET PASSWORD FOR da_admin@localhost = OLD_PASSWORD('yourpassword');
 
finally i got it right!

i just changed mysql root password according to the one listed at mysql.conf, and everything worked!

fantastic! thank you all!!!
 
Last edited:
You must log in or register to reply here.
Back
Top