Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== MySQL ======

{{:mysql:mysql.png?200 |}}

**MySQL** is an open-source relational database management system.

----

[[MySQL:Add a column to an existing table|Add a column to an existing table]]

[[MySQL:Add unique to an existing column|Add unique to an existing column]]

[[MySQL:Change a column name|Change a column name]]

[[MySQL:Change passwords|Change passwords]]

[[MySQL:Column Level Privileges|Column Level Privileges]]

[[MySQL:Configure utf8mb4|Configure utf8mb4]]

[[MySQL:Database API|Database API]]

[[MySQL:Debugging messages|Debugging messages]]

[[MySQL:Difference Between ALTER, CHANGE, and MODIFY COLUMN|Difference Between ALTER, CHANGE, and MODIFY COLUMN]]

[[MySQL:Error 1071|Error #1071 - Specified key was too long; max key length is 767 bytes]]

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

[[MySQL:Error index name too long using rails|Error index name too long using rails]]

[[MySQL:Error Java JDBC connection to MySQL null dates exception|Error Java JDBC connection to MySQL null dates exception]]

[[MySQL:Error Library not loaded: libmysqlclient.18.dylib|Error Library not loaded: libmysqlclient.18.dylib]]

[[MySQL:Exclude DROP and CREATE TABLE From mysqldump|Exclude DROP and CREATE TABLE From mysqldump]]

[[MySQL:Export database schema|Export database schema]]

[[MySQL:Export entire database|Export entire database]]

[[MySQL:Export users with grants|Export users with grants]]

[[MySQL:Finding and Deleting Orphaned Rows|Finding and Deleting Orphaned Rows]]

[[MySQL:Get All Databases Sizes|Get All Databases Sizes]]

[[MySQL:Import a database|Import a database]]

[[MySQL:Import a file|Import a file]]

[[MySQL:Login without a password|Login without a password]]

[[MySQL:Password Recovery|Password Recovery]]

[[MySQL:Performance using case insensitive columns|Performance using case insensitive columns]]

[[MySQL:Prepping MySQL Indexes for a Character Set Change|Prepping MySQL Indexes for a Character Set Change]]

[[MySQL:Privileges|Privileges]]

[[MySQL:Recover the MySQL root password|Recover the MySQL root password]]

[[MySQL:Remove a column|Remove a column]]

[[MySQL:Repair Table|Repair Table]]

[[MySQL:Replication|Replication]]

[[MySQL:Reset root password|Reset root password]]

[[MySQL:Restore a specific table from a SQL dump file|Restore a specific table from a SQL dump file]]

[[MySQL:Secure MySQL|Secure MySQL]]

[[MySQL:Storing IP|Storing IP]]

[[MySQL:Storing UUID|Storing UUID]]

[[MySQL:Troubleshoot MySQL SSL Replication Problems|Troubleshoot MySQL SSL Replication Problems]]

----

===== References =====

https://www.mysql.com/