Mysql problem: after changing root password, cannot start onboot
I have a master-master setup (using heartbeat) and recently, the 1st master password has been lost.. so I change it by stopping the service, and restarting it using --skip-grant-tables. thereafter i change it but when i try to restart the service I get a "MySQL manager or server PID file could not be found" error.
I tried removing my entire my.cnf and the service work. I figure it is something to do with the replication (corrupted?) but i have no idea how I should go about restoring/troubleshooting.. anyone can guide?
Right now, I manually start mysql by executing mysqld -uroot --relay-log=db1-relay-bin
Replication is still working, just that it cannot start on boot...
Last edited by Swakoo; 09-17-2007 at 10:37 PM.