advancedfuture Posted December 23, 2008 Share Posted December 23, 2008 The past couple of days I have been trying to figure out why mysql keeps losing the root password randomly and bringing all my websites down. Then I figured it out! I was SSHd into my server and saw a broadcast message "cPanel Layer 2 Update Complete" Then immediately afterwards I noticed all my sites were down giving "MySql Query Error", so I logged into mysql and reset my password and all sites came back up.. How can I stop this from happening? It is happening daily. It got so bad that my main site's homepage got crawled while it was down and indexed as "mysql query error" and my traffic went from 150 uniques a day to almost zero! Quote Link to comment https://forums.phpfreaks.com/topic/138216-upcp-runs-and-mysql-loses-root-password/ Share on other sites More sharing options...
fenway Posted December 23, 2008 Share Posted December 23, 2008 Who set up cPanel -- ask them. Quote Link to comment https://forums.phpfreaks.com/topic/138216-upcp-runs-and-mysql-loses-root-password/#findComment-722620 Share on other sites More sharing options...
advancedfuture Posted December 23, 2008 Author Share Posted December 23, 2008 I set it up, it is on my dedicated server. However I no longer use cPanel. Can i just rename upcp to keep it from running? Quote Link to comment https://forums.phpfreaks.com/topic/138216-upcp-runs-and-mysql-loses-root-password/#findComment-722629 Share on other sites More sharing options...
fenway Posted December 23, 2008 Share Posted December 23, 2008 Why not just uninstall it? Quote Link to comment https://forums.phpfreaks.com/topic/138216-upcp-runs-and-mysql-loses-root-password/#findComment-722634 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.