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… Read More »XAMPP MySQL fails to start: ‘InnoDB’ ENGINE failed
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… Read More »Get all databases size of an instance/server in MB or GB (Human readable format)
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… Read More »MySQL wait_timeout and sleep connections.
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… Read More »Auto start MySQL on Mac startup
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… Read More »Fix Mysql error – 2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)