Repair MySQL database with mysqlcheck
To check and repair all databases in a database run mysqlcheck -A –auto-repair -u root -p Forcefully optimize all tables, automatically fixing…
MySQL
MySQL Unknown collation: ‘utf8mb4_0900_ai_ci’
When restoring a MySQL 8 database backup on a MariaDB server, I get the following error To fix this error, open the…
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 sudo rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm Install MySQL 5.7…
MySQL Your password does not satisfy the current policy requirements
When i try to create MySQL user on a server, i get following error mysql> GRANT ALL PRIVILEGES ON *.* TO ‘centovacast’@’localhost’…
Change MySQL user password
To change the password for a MySQL user, run mysqladmin -u user_name_here -p password new_password_here Or via SQL UPDATE mysql.user SET Password=PASSWORD(‘NEW_PASSWORD_HERE’)…
Reset MySQL root password on Bitnami server
To reset MySQL root password on Bitnami server, first check MySQL server version you are running. mysql –version Create a file vi…
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 to 16384.…
MySQL Can’t create new tempfile
When i try to repair a crashed database table, i get error mysql> repair table visitorstats_sessions; +————————————-+——–+———-+————————————————————————+ | Table | Op |…
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 the error,…
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 file mkdir…
Find MySQL Database and Table Size
To find the size of databases using SQL command, run the following SQL in MySQL prompt. Example FInd disk usage by tables…