Can’t open and lock privilege tables: Incorrect file format ‘db’
ubuntu 16.04 LTS，mysql 5.7.23
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf，在[mysql]行后增加 skip-grant-tables，让mysql服务在启动的时候不检查表的权限
启动服务后，mysql -uroot -p
1mysql> use mysql; 2mysql> repair db use_frm; 3+----------+--------+----------+----------+ 4| Table | Op | Msg_type | Msg_text | 5+----------+--------+----------+----------+ 6| mysql.db | repair | status | OK | 7+----------+--------+----------+----------+ 81 row in set (0.00 sec) 9 10mysql> exit
修复mysql.db表后，编辑/etc/mysql/mysql.conf.d/mysqld.cnf文件，把skip-grant-tables行注释掉，重启mysql服务
1update-alternatives: error: alternative path /etc/mysql/my.cnf.fallback doesn't exist 2dpkg: error processing package mysql-common (--configure): 3 subprocess installed post-installation script returned error exit status 2 4dpkg: dependency problems prevent configuration of mysql-client-5.7: 5 mysql-client-5.7 depends on mysql-common (>= 5.5); however: 6 Package mysql-common is not configured yet. 7 8dpkg: error processing package mysql-client-5.7 (--configure): 9 dependency problems - leaving unconfigured 10No apport report written because the error message indicates its a followup error from a previous failure. 11 Errors were encountered while processing: 12 mysql-common 13 mysql-client-5.7 14 15 16$ sudo mkdir -p /etc/mysql/my.cnf.fallback 17$ sudo chown mysql.mysql /etc/mysql 18$ sudo apt instal mysql-common mysql-server 19 20 21Reading package lists... Done 22Building dependency tree 23Reading state information... Done 240 upgraded, 0 newly installed, 0 to remove and 49 not upgraded. 252 not fully installed or removed. 26After this operation, 0 B of additional disk space will be used. 27Setting up mysql-server-5.7 (5.7.24-0ubuntu0.16.04.1) ... 28update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist 29dpkg: error processing package mysql-server-5.7 (--configure): 30 subprocess installed post-installation script returned error exit status 2 31dpkg: dependency problems prevent configuration of mysql-server: 32 mysql-server depends on mysql-server-5.7; however: 33 Package mysql-server-5.7 is not configured yet. 34 35dpkg: error processing package mysql-server (--configure): 36 dependency problems - leaving unconfigured 37No apport report written because the error message indicates its a followup error from a previous failure. 38 Errors were encountered while processing: 39 mysql-server-5.7 40 mysql-server 41E: Sub-process /usr/bin/dpkg returned an error code (1) 42 43 44$ sudo apt-get remove --purge mysql-\* 45$ sudo apt-get install mysql-server mysql-client
ref: https://blog.csdn.net/qingchuwudi/article/details/52593501