Skip to content

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