MySQL
Written by Yujin Boby
Edit in WordPress- 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
MySQL Utils
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