User Tools

Site Tools


ubuntu:mysql

This is an old revision of the document!


MySQL

Add a column to an existing table

Add unique to an existing column

Change a column name

Change passwords

Column Level Privileges

Configure utf8mb4

Database API

Debugging messages

Difference Between ALTER, CHANGE, and MODIFY COLUMN

Error #1071 - Specified key was too long; max key length is 767 bytes

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

Error index name too long using rails

Error Java JDBC connection to MySQL null dates exception

Error Library not loaded: libmysqlclient.18.dylib

Exclude DROP and CREATE TABLE From mysqldump

Export database schema

Export entire database

Export users with grants

Finding and Deleting Orphaned Rows

Import a database

Import a file

Login without a password

Password Recovery

Performance using case insensitive columns

Prepping MySQL Indexes for a Character Set Change

Privileges

Recover the MySQL root password

Remove a column

Repair Table

Replication

Restore a specific table from a SQL dump file

Secure MySQL

Storing IP

Storing UUID

Troubleshoot MySQL SSL Replication Problems


Add a column to an existing table

Add unique to an existing column

Change a column name

Change passwords

Column Level Privileges

Configure utf8mb4

Database API

Debugging messages

Difference Between ALTER, CHANGE, and MODIFY COLUMN

Error #1071 - Specified key was too long; max key length is 767 bytes

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

Error index name too long using rails

Error Java JDBC connection to MySQL null dates exception

Error Library not loaded: libmysqlclient.18.dylib

Exclude DROP and CREATE TABLE From mysqldump

Export database schema

Export entire database

Export users with grants

Finding and Deleting Orphaned Rows

Import a database

Import a file

Login without a password

Password Recovery

Performance using case insensitive columns

Prepping MySQL Indexes for a Character Set Change

Privileges

Recover the MySQL root password

Remove a column

Repair Table

Replication

Restore a specific table from a SQL dump file

Secure MySQL

Storing IP

Storing UUID

Troubleshoot MySQL SSL Replication Problems

ubuntu/mysql.1575123839.txt.gz · Last modified: 2020/07/15 09:30 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki