一、问题呈现
mysql> create user 'turn123'@'localhost' identified by 'abcd123';
ERROR 1805 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted
二、解决办法
1、升级配置
$ /usr/bin/mysql_upgrade -uroot -p -S /var/lib/mysql/mysql.sock
Enter password:
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
Upgrade process completed successfully.
Checking if update is needed.
2、再次登录MySQL验证
$ mysql -uroot -p
mysql> create user 'turn123'@'localhost' identified by 'abcd123';
Query OK, 0 rows affected (0.08 sec)