Both sides previous revisionPrevious revisionNext revision | Previous revision |
ubuntu:mysql [2019/11/30 17:44] – peter | ubuntu:mysql [2022/10/14 00:50] (current) – ↷ Links adapted because of a move operation 114.119.136.155 |
---|
====== MySQL ====== | ====== MySQL ====== |
| |
[[MySQL:Change a column name|Change a column name]] | [[database:mysql|MySQL]] |
| |
[[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]] | |
| |
| |
---- | |
| |
[[Ubuntu:MySQL:Add a column to an existing table|Add a column to an existing table]] | |
| |
[[Ubuntu:MySQL:Add unique to an existing column|Add unique to an existing column]] | |
| |
[[Ubuntu:MySQL:Change a column name|Change a column name]] | |
| |
[[Ubuntu:MySQL:Change passwords|Change passwords]] | |
| |
[[Ubuntu:MySQL:Column Level Privileges|Column Level Privileges]] | |
| |
[[Ubuntu:MySQL:Configure utf8mb4|Configure utf8mb4]] | |
| |
[[Ubuntu:MySQL:Database API|Database API]] | |
| |
[[Ubuntu:MySQL:Debugging messages|Debugging messages]] | |
| |
[[Ubuntu:MySQL:Difference Between ALTER, CHANGE, and MODIFY COLUMN|Difference Between ALTER, CHANGE, and MODIFY COLUMN]] | |
| |
[[Ubuntu:MySQL:Error 1071|Error #1071 - Specified key was too long; max key length is 767 bytes]] | |
| |
[[Ubuntu: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']] | |
| |
[[Ubuntu:MySQL:Error index name too long using rails|Error index name too long using rails]] | |
| |
[[Ubuntu:MySQL:Error Java JDBC connection to MySQL null dates exception|Error Java JDBC connection to MySQL null dates exception]] | |
| |
[[Ubuntu:MySQL:Error Library not loaded: libmysqlclient.18.dylib|Error Library not loaded: libmysqlclient.18.dylib]] | |
| |
[[Ubuntu:MySQL:Exclude DROP and CREATE TABLE From mysqldump|Exclude DROP and CREATE TABLE From mysqldump]] | |
| |
[[Ubuntu:MySQL:Export database schema|Export database schema]] | |
| |
[[Ubuntu:MySQL:Export entire database|Export entire database]] | |
| |
[[Ubuntu:MySQL:Export users with grants|Export users with grants]] | |
| |
[[Ubuntu:MySQL:Finding and Deleting Orphaned Rows|Finding and Deleting Orphaned Rows]] | |
| |
[[Ubuntu:MySQL:Import a database|Import a database]] | |
| |
[[Ubuntu:MySQL:Import a file|Import a file]] | |
| |
[[Ubuntu:MySQL:Login without a password|Login without a password]] | |
| |
[[Ubuntu:MySQL:Password Recovery|Password Recovery]] | |
| |
[[Ubuntu:MySQL:Performance using case insensitive columns|Performance using case insensitive columns]] | |
| |
[[Ubuntu:MySQL:Prepping MySQL Indexes for a Character Set Change|Prepping MySQL Indexes for a Character Set Change]] | |
| |
[[Ubuntu:MySQL:Privileges|Privileges]] | |
| |
[[Ubuntu:MySQL:Recover the MySQL root password|Recover the MySQL root password]] | |
| |
[[Ubuntu:MySQL:Remove a column|Remove a column]] | |
| |
[[Ubuntu:MySQL:Repair Table|Repair Table]] | |
| |
[[Ubuntu:MySQL:Replication|Replication]] | |
| |
[[Ubuntu:MySQL:Restore a specific table from a SQL dump file|Restore a specific table from a SQL dump file]] | |
| |
[[Ubuntu:MySQL:Secure MySQL|Secure MySQL]] | |
| |
[[Ubuntu:MySQL:Storing IP|Storing IP]] | |
| |
[[Ubuntu:MySQL:Storing UUID|Storing UUID]] | |
| |
[[Ubuntu:MySQL:Troubleshoot MySQL SSL Replication Problems|Troubleshoot MySQL SSL Replication Problems]] | |
| |
| [[Ubuntu:MySQL:Install MySQL|Install MySQL]] |