MySQL

MySQL is an open-source relational database management system.


Add a column to an existing table

Add unique to an existing column

Change a column name

Change passwords

Column Level Privileges

Configure utf8mb4

Database API

Debugging messages

Difference Between ALTER, CHANGE, and MODIFY COLUMN

Error #1071 - Specified key was too long; max key length is 767 bytes

Error Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Error index name too long using rails

Error Java JDBC connection to MySQL null dates exception

Error Library not loaded: libmysqlclient.18.dylib

Exclude DROP and CREATE TABLE From mysqldump

Export database schema

Export entire database

Export users with grants

Finding and Deleting Orphaned Rows

Import a database

Import a file

Login without a password

Password Recovery

Performance using case insensitive columns

Prepping MySQL Indexes for a Character Set Change

Privileges

Recover the MySQL root password

Remove a column

Repair Table

Replication

Restore a specific table from a SQL dump file

Secure MySQL

Storing IP

Storing UUID

Troubleshoot MySQL SSL Replication Problems