MySQL

• Find all MySQL databases using InnoDB engine
• Find MySQL Server Version

MySQL Installation

• Install MySQL 8 on CentOS 6/7
• Install MySQL 8 on Ubuntu/Debian
• MySQL root can’t login to phpMyAdmin
• How to Disable MySQL Strict Mode

MySQL User Management

• Reset MySQL root Password
• Change MySQL root password

MySQL Optimize

• MySQL Optimize
• Enable Slow Query Log in MySQL

MySQL Backup/Restore

• mysqldump
• MySQL Unknown collation: utf8mb4_unicode_520_ci
• ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_ci’

MySQL GUI

• https://www.sequelpro.com – GUI Application for MAC.
• MySQL Workbench – Linux, Windows, MAC
• https://www.heidisql.com

MySQL Errors

• MySQL Permission denied
• MySQL not starting on Ubuntu 18.04 (AppArmour)
• ERROR 2006 (HY000) at line 348: MySQL server has gone away
• MySQL Out of resources when opening file
• MySQL Got error 24 Too many open files