MySQL root password question

[nobaloney]

I think I understand that the mysql root password is the original admin password.

Someone please correct me if I'm wrong.

Now my question is what happens when the admin password is changed?

Obviously the root password isn't changed if the admin password is changed through the linux passwd command. Is it changed if the admin passwd is changed through the DA password change feature in the control panel?

What stops working if one is changed and the other isn't?

What stops working if the "root' password is changed through a mysql shell login?

Can I find the password anywhere on the server?

I'm going nuts today. While I'm almost always half nuts, help with this would be greatly appreciated .

Jeff

 

[ballyn]

I believe that the install.sh script writes the mysql root password to the setup.txt file on the mysql= line, and that password is used in the mysql.sh script to set the initial mysql root password. That's the only place that I think you could find the mysql root password.

The mysql.sh script then creates the da_admin mysql user which has the same password as the admin system account--but not the same password as the mysql root account.

AFAIK, DA never uses or modifies the mysql root password nor does it ever modify the da_admin mysql password. So, the mysql root password can safely be changed without affecting the operation since DA will always use the da_admin mysql account for the mysql functions. This password is stored in the mysql.conf file and must be changed there if you change the da_admin mysql password.

The relevant methods are doMySQL() in install.sh and setRootPass() and setDAuser() in mysql.sh.

HTH,
Allyn