msyqld启动不了:ERROR 130 (HY000): Incorrect file format 'user'

File: /var/log/mysql/error.log ：

mysqld: Incorrect file format 'plugin'

100101  0:38:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

100101  0:38:12 InnoDB: The InnoDB memory heap is disabled

100101  0:38:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins

100101  0:38:12 InnoDB: Compressed tables use zlib 1.2.7

100101  0:38:12 InnoDB: Using Linux native AIO

100101  0:38:12 InnoDB: Initializing buffer pool, size = 128.0M

100101  0:38:12 InnoDB: Completed initialization of buffer pool

100101  0:38:12 InnoDB: highest supported file format is Barracuda.

100101  0:38:12  InnoDB: Waiting for the background threads to start

100101  0:38:13 InnoDB: 1.1.8 started; log sequence number 1595685

100101  0:38:13 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306

100101  0:38:13 [Note]   - '127.0.0.1' resolves to '127.0.0.1';

100101  0:38:13 [Note] Server socket created on IP: '127.0.0.1'.

100101  0:38:13 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host'

root@cubietruck:/usr/sbin/mysqld --skip-grant

root@cubietruck:mysql -u root

mysql>use mysql;

mysql> select * from user;

ERROR 130 (HY000): Incorrect file format 'user'

问题可能是mysqlmysql的配置文件my.cnf（通常位置在/etc/mysql/my.cnf ）,找到datadir的路径，我的是:

/var/lib/mysql, 把mysql卸载掉然后重现安装。问题解决。

卸载:apt-get remove mysql-server*

         apt-get remove mysql-client*

 apt-get remove mysql-dev*

安装:

apt-get -y --force-yes install mysql-server

apt-get -y --force-yes install mysql-client

apt-get -y --force-yes install libmysqld-dev