- On Linux, run: `sudo systemctl status mysql`
- On Windows, open Services and look for MySQL service.
- Run: `mysql -h [hostname] -u [username] -p`
- Connect to MySQL: `mysql -u [username] -p`
- List databases: `SHOW DATABASES;`
- Ensure the targeted database is listed.
- After connecting to MySQL: `SHOW GRANTS FOR 'youruser'@'yourhost';`
- Default location on Linux: `/var/log/mysql/error.log`
- On Windows, located in MySQL installation directory, `data` folder.
- On Linux: `df -h`
- On Windows: Open This PC and check the disk where MySQL is installed.
- Connect to MySQL and run: `SHOW STATUS LIKE 'uptime';` to check if the server is running.
- Check open connections: `SHOW STATUS LIKE 'Threads_connected';`
- Connect to MySQL and run: `REPAIR TABLE tablename;` for the specific table(s) reported in errors, or
- Use myisamchk for MyISAM tables if the server is stopped: `myisamchk --recover /path/to/table.MYI`
- Check max connections: `SHOW VARIABLES LIKE 'max_connections';`
- Temporarily increase: `SET GLOBAL max_connections = [higher number];`
- On Linux: `sudo systemctl restart mysql`
- On Windows: Restart the MySQL service from Services.
Perform these actions in sequence, checking after each step if the error persists before proceeding to the next.
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)