User Tools

Site Tools


mysql:mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
mysql:mysql [2020/04/02 09:10] petermysql:mysql [2020/07/15 10:30] – external edit 127.0.0.1
Line 1: Line 1:
 ====== MySQL ====== ====== MySQL ======
  
-[[MySQL:MySQL:Reset root password|Reset root password]]+{{: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: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/ 
mysql/mysql.txt · Last modified: 2021/07/23 11:01 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki