Archives for Database
Mysql import from 5.6 to 5.7 : Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted
You might receive the error Column count of is wrong. Expected 42, found 44. The table is probably corrupted , this is probably because you import the whole...
Mysql: creating a new user and assign all permission to it
i create this user for my backup script:
Ubuntu – change mysql root password
This is a bit gnarly. If you have a better method of updating the password without triggering a warning about PASSWORD being deprecated, I’m all ears. Update the...
Mysql Replication error: Slave failed to initialize relay log info structure from the repository after changing hostname
Below are the steps to fix this issue: 1. Shut down your old slave server and make a copy of the data directory to your new slave. Make sure...
Disable SQL strict mode in Mysql 5.7
Add this to /etc/
Mysql: how to check the maximum connections that the server has handled?
You can run this command to find the maximum connections that the server has served since it starts? it’s useful when we want to know if sometimes we reach...
Mysql replication error – relay log file corrupted
SQL Thread is not running When relay log is corrupted , meaning the slave server is stopped unexpectedly How to fix: – run show slave , we’ll see the...
Mysqldump multiple database , tables
Dump multiple databases: Dump some selected tables: Dome all tables except some tables:
Mysql 5.7 : How to enable slow query logs
If you just uncomment the slow query log variable in , you can’t start your mysql server. it’s because the variable name has changed, the following configuration works...
Mysql – repair/check all tables in all databases
The below command will go through all tables in all database databases to do a repair check.