This page links all MySQL related HOW-TOS.

Install MySQL

• Install MariaDB on CentOS 7
• Install MariaDB on CentOS 6
• Install Percona Server (MySQL)
• Disable MySQL Strict Mode

Secure MySQL

• Secure MySQL Installation with mysql_secure_installation
• MySQL Configuration

MySQL Optimization

• MySQL Optimization
• How To Move MySQL Data Directory (datadir)
• Slow Query Log

MySQL Server Info

• MySQL Show all Supported Database Engines

Working With MySQL

• Create MySQL user.
• Change MySQL Root Password
• How to change MYSQL root password in windows 7
• mysqladmin
• Storing MySQL password in ~/.my.cnf

Reset MySQL root Password

• Reset MySQL root password.
• Find MySQL root password in Plesk Server.
• Change MySQL root Password in Cpanel Server.

Troubleshooting MySQL

• MariaDB Too many connections
• What to Do if MariaDB Doesn’t Start
• MySQL Can’t open and lock privilege tables
• InnoDB Error log file ib_logfile0 is of different size
• PHP can’t connect to MySQL running on localhost
• Ubuntu 16 mysqldump Got packet bigger than max_allowed_packet

Repair

• mysqlcheck – Repair MySQL database with mysqlcheck
• Repair MySQL MyISAM Database with myisamchk

MySQL Failed to start

• InnoDB: mmap(x bytes) failed; errno 12

MySQL Backup

• mysqldump
• MySQL Data Directory Backup with Rsync
• MySQL Out of resources when opening file