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 mysql.user is wrong. Expected 42, found 44. The table is probably corrupted…
-
-
Mysql: creating a new user and assign all permission to it
i create this user for my backup script: [crayon-685d47532c002576866026/]
-
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…
-
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…
-
Disable SQL strict mode in Mysql 5.7
Add this to /etc/mysql/mysqld.conf/mysqld.conf [crayon-685d47532c303038386888/]
-
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…
-
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…
-
Mysqldump multiple database , tables
Dump multiple databases: [crayon-685d47532c587944676086/] Dump some selected tables: [crayon-685d47532c588596807058/] Dome all tables except some tables: [crayon-685d47532c589414587044/]
-
Mysql 5.7 : How to enable slow query logs
If you just uncomment the slow query log variable in mysqld.conf , you can’t start your mysql server. it’s because…
-
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. [crayon-685d47532c742291437171/]