| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| mysql:mysql [2020/04/02 09:10] – peter | mysql:mysql [2021/07/23 11:01] (current) – peter |
|---|
| ====== MySQL ====== | ====== 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: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/ |
| | |
