Both sides previous revisionPrevious revision | |
database:mysql [2022/10/11 12:42] – removed - external edit (Unknown date) 127.0.0.1 | database:mysql [2022/10/11 12:42] (current) – ↷ Page moved from programming:mysql to database:mysql peter |
---|
| ====== MySQL ====== |
| |
| {{:programming:mysql.png?100 |}} |
| |
| **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: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: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]] |
| |
| |
| ---- |
| |