MySQL

• MySQL Cluster
• MySQL 8
• Find all MySQL databases using InnoDB engine
• Find MySQL Server Version
• Find MySQL Database and Table Size
• MySQL see all charsets
• MySQL show processlist
• Free MySQL Database Hosting

MySQL Installation

• MySQL Install
• MySQL root can’t login to phpMyAdmin
• How to Disable MySQL Strict Mode
• MySQL Initialize Data Directory
• How to create MySQL data directory with mysql_install_db
• Limit disk used by MySQL binary log files
• How to disable MySQL X Protocol (mysqlx_port)
• How to change MySQL Datadir in Cpanel Server

MySQL User Management

• Create MySQL User
• MySQL create database
• Change or Reset MySQL root Password
• MySQL Database Character Set and Collation
• How to create MySQL read-only user

MySQL Optimize

• MySQL Optimize
• Enable Slow Query Log in MySQL
• Percona Monitoring and Management
• Convert MySQL MyISAM tables to InnoDB

MySQL Backup/Restore

• MySQL Backup
• How to Migrate MySQL Users to Another Server
• How to Recover MySQL Table Structure from .frm File

MYSQL Commands

• How to rename a MySQL database table

MySQL Utils

• Auto Restart MySQL if Crashed

MySQL GUI

• Dbeaver.io – Support Windows, Linux and Mac.
• https://www.sequelpro.com – GUI Application for MAC.
• MySQL Workbench – Linux, Windows, MAC
• https://www.heidisql.com
• https://dbgate.org
• https://www.adminer.org
• https://www.phpmyadmin.net

MySQL Errors

• MySQL Permission denied
• MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’
• MySQL server has gone away
• 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
• Ubuntu 18.04 MariaDB 10.2 Too many open files
• MySQL Recovering after a crash using tc.log
• Aria engine is not enabled or did not start
• MySQL cannot connect via localhost
• MariaDB ERROR 1524 Plugin unix_socket is not loaded
• ERROR 1118 Row size too large Changing some columns to TEXT or BLOB may help.
• MySQL ERROR Unable to create or change a table without a primary key
• MariaDB Change Open Files Limit
• InnoDB: space header page consists of zero bytes in tablespace
• myisamchk: Argument list too long
• Your password does not satisfy the current policy requirements
• MySQL 8 server requested authentication method unknown to the client
• Magento ERROR 1005 (HY000) Can’t create table catalog_product_relation (errno: 140 “Wrong create options”)
• ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded
• ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
• MySQL ERROR 1114 (HY000) at line 2137: The table ‘X’ is full
• Can’t create table catalog_product_relation (errno: 140 “Wrong create options”)
• MySQL Specified key was too long; max key length is 767 bytes
• MySQL 5.7 Community Server GPG keys already installed but they are not correct
• Plesk Debian 8 General error: 23 Out of resources when opening
• How to fix InnoDB: ERROR: the age of the last checkpoint
• mysqldump Lost connection to MySQL server during query when dumping table