By badrd
I have a PHP application written with codeigniter that connects to MySQL just fine for two months. Yesterday, it couldn’t connect to it, showing an error message that there was an error in the configuration or something! I did not change any settings at that time… I tried to log in with phpmyadmin it told me this message “Connection for controluser as defined in your configuration failed”. So, now I know that neither me nor the application can connect to the MySQL server. Restarted the droplet and everything got back to normal! Today, it did the same thing again -_-, just made a reboot and its fine again…
My question is: What is the real problem so I can prevent this from happening again?
PS: I kinda noticed a new database now within MySQL i am not sure if it was “mysql” or “phpmyadmin” but i am sure they both were not in there… I use the root username. Droplet runs Ubuntu.
Thanks in advance…
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
I am facing the same issue. After every few days, i see this error and i have to restart the droplet which resolves the issue. Need to know the root cause behind this. Please help me.
if you have configured MYsql correctly with its new pass, then you should be fine. <br> <br>remember some security issues could block you from login such as iptables or fail2ban and so on… <br> <br>make sure your firewall doesn’t block mysql port 3306 <br> <br>you can always check your database after creating : <br> <br>http://www.cyberciti.biz/faq/mysql-command-to-show-list-of-databases-on-server/
@FMCB there was no password change, I don’t use iptables nor fail2ban… Nothing was changed! <br>till now it didn’t do it again so… i dont know
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.