How to Install MySQL 5.7 on Amazon Linux
Amazon Linux 2 come with MariaDB by default. To install MySQL 5.7, install repository with Install MySQL 5.7 with Set
MySQL Your password does not satisfy the current policy requirements
When i try to create MySQL user on a server, i get following error This is due to MySQL validate
Change MySQL user password
To change the password for a MySQL user, run Or via SQL See MySQL
MySQL Install
How to install MySQL 5.6 on CentOS 7 Install MySQL as Service in Windows MariaDB Install Latest MariaDB on CentOS
Reset MySQL root password on Bitnami server
To reset MySQL root password on Bitnami server, first check MySQL server version you are running. Create a file Add
MariaDB Change Open Files Limit
When using systemctl, you can set value for open_files_limit in my.cnf file. Default installation of MariaDB 10 have open_files_limit set
MySQL Can’t create new tempfile
When i try to repair a crashed database table, i get error Check the table with myisamcheck It reported some
Split mysqldump backup file into tables
I had to restore a large MySQL backup file. When restoring one of the table resulted in error. To debug
Auto Restart MySQL if Crashed
This bash script is used to auto-restart MySQL or MariaDB database if it crashes or stops for any reason. Create
Find MySQL Database and Table Size
To find size of database using SQL command, run following SQL in MySQL promt. Example FInd disk usage by tables
MySQL ERROR Unable to create or change a table without a primary key
When trying to restore a database backup to Managed DigitialOcean MySQL 8 database, i get following error This is because
ERROR 1118 Row size too large Changing some columns to TEXT or BLOB may help.
When restoring a MySQL database, i get error I installed exactly same MraiaDB version on both source and destination server.