How to Install MySQL in Linux

Installing MySQL Server Community Edition

MySQL Installed File Location 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

MySQL Shell Command

Connect to MySQL using Unix Socket File

Login to MySQL without Credentials

How to Execute MySQL Queries Directly from the Linux Command Line

Download MySQL Sample World Database

How to Check and Repair MySQL Tables Using Mysqlcheck

How to install MySQL shell on Ubuntu


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

Change Character set and collation in Tables and Columns in Mysql 8


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 TABLE  command denied to user 'root'@'localhost' for table 'accounts' when using LOCK  TABLES

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Error: Access denied for user 'root'@'localhost' (using password: YES)

Conflicting request  Error during installing MySQL in Amazon Linux EC2 Instance

Unable to locate package mysql-shell


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