使用my-innodb-heavy-4g.chf 后mysql无法启动

shengziyang

军哥，帮我找找错误原因，我恢复到原来的的my.cnf也还是同样问题。

140724 13:04:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140724 13:04:32 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
/usr/local/mysql/bin/mysqld: Unknown error 1146
140724 13:04:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140724 13:04:32 InnoDB: The InnoDB memory heap is disabled
140724 13:04:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140724 13:04:32 InnoDB: Compressed tables use zlib 1.2.7
140724 13:04:32 InnoDB: Initializing buffer pool, size = 4.0G
140724 13:04:32 InnoDB: Completed initialization of buffer pool
140724 13:04:32  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /usr/local/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
140724 13:04:32 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

licess

系统里可能还有其他mysql存在
用yum或apt-get 安装的一般数据库在/var/lib/mysql
建议用rpm -qa|grep mysql 或dpkg -l|grep mysql 看一下

如果要用heavy-4g的配置文件需要将里面的一些配置要改掉
如启用了，需要修改datadir      = 还需要修改innodb_data_home_dir 和innodb_log_group_home_dir 为你数据库目录

shengziyang

/# dpkg -l|grep mysql
ii  libdbd-mysql-perl                4.021-1+b1                 amd64        Per                l5 database interface to the MySQL database
ii  libmysqlclient18:amd64           5.5.37-0+wheezy1           amd64        MyS                QL database client library
ii  mysql-common                     5.5.37-0+wheezy1           all          MyS                QL database common files, e.g. /etc/mysql/my.cnf
# rpm -qa|grep mysql
bash: rpm: command not found

licess

apt-get remove mysql-common
然后rm -rf /etc/mysql/
再启动mysql应该就行了

shengziyang

很奇怪的是，我按照上述操作了后还是启动不了，日志文件如下：

140731 16:07:55  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /usr/local/mysqlar/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
140731 16:07:55 mysqld_safe mysqld from pid file /usr/local/mysqlar/shenziyang.pid ended
140731 16:08:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysqlar
^G/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140731 16:08:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140731 16:08:12 InnoDB: The InnoDB memory heap is disabled
140731 16:08:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140731 16:08:12 InnoDB: Compressed tables use zlib 1.2.7
140731 16:08:12 InnoDB: Initializing buffer pool, size = 4.0G
140731 16:08:13 InnoDB: Completed initialization of buffer pool
140731 16:08:13  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /usr/local/mysqlar/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
140731 16:08:13 mysqld_safe mysqld from pid file /usr/local/mysqlar/shenziyang.pid ended