MySQL Root Password issues

Hi,

The root password for the MySQL server keeps coming up with a problem. I kills all access to the MySQL databases. When I see it, I log in and run the script to reset the root password and everything is fine. Problem is, I don't know when the password stops working so I need to monitor it all the time. Once it did this in the middle of the night and I didn't see it until 8 hours later, causing a lot of issues.

Reset script: /scripts/mysql_pwd_reset

Possible resolve - testing now:

Code: [Select]

yum --enablerepo=remi update mysql-server