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

[knoxhosting]

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?

 

[knoxhosting]

Found it -- it's recorded in the setup.txt file. <<WHEW>>

 

[jmstacey]

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

 

[knoxhosting]

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.

 

[jmstacey]

Give this a try: http://help.directadmin.com/item.php?id=45

 

[knoxhosting]

Worked Perfect!! Thank YOU!

FYI --- Typo in the second box:

FLUSH PRIVILEGS;

 

[jmstacey]

I'll let DirectAdmin know

 

[interfasys]

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');

 

[neorder]

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!!!