MySQL

How to Install MySQL in Linux

Reset MySQL forgotten root Password

MySQL Backup and Recovery

Backup and Restore MySQL database using mysqldump

How to Copy MySQL database from one server to another

SQL:

Useful SQL Command (MySQL)

Mysql User and privileges

How to find MySQL version

How to change root password in MySQL

Delete huge number of rows from Table in MySQL database

Password Authentication Using mysql_config_editor in MySQL

Database Change:

Set auto_crement on existing table (MySQL)

MySQL Case Insensitive Table

Increase MySQL connection limit

Rename Partition in Mysql Database

Error:

ERROR 1062 (23000): ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'

ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number

ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts' when using LOCK TABLES

Script:

Script to create Weekly partition based on Unix Time Stamp in mysql