MySQL
Reset MySQL forgotten root Password
Backup and Restore MySQL database using mysqldump
How to Copy MySQL database from one server to another
SQL:
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)
Increase MySQL connection limit
Rename Partition in Mysql Database
Error:
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