Some times MySQL fails to start/restart with an error like “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed” The simple solution to fix is to delete InnoDB log files “ib_logfile0” and “ib_logfile1“. Steps to delete…
Read More
To List all databases with its size in MB or GB, below command can be used to get the information. Below is the command to list all databases with its size in MB. SELECT table_schema…
For cases where an application fails to close a connection it is no longer using, a low wait_timeout value can help to avoid hitting max_connections simply due to sleeping idle connections that are not in a…
If enabling “Automatically Start MySQL Server on Startup” does not work then doing below process will fix it. Open terminal/command line interface (CLI) and run below commands. run “sudo vi /Library/LaunchDaemons/com.mysql.mysql.plist” and add below code…
Sometimes opening phpMyAdmin can give below error due to incorrect setting done somehow. “2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)“ To FIx this run mysqld-debug.exe and then…