mysql启动问题-优快云博客

本文记录了一次MySQL启动失败的问题及解决过程。启动时遇到了错误提示，指出mysql.plugin表不存在，并建议运行mysql_upgrade来创建该表。文章进一步说明了如何通过检查和调整basedir和datadir配置来解决问题。

最近遇到mysql 启动问题

[root@localhost mysql]# /etc/init.d/mysqld start
Starting MySQL.........The server quit without updating PID file (/app/mysql/localhost.localdomain.pid).[FAILED]

可以在mysql errorlog中看到

140508 14:15:19 mysqld_safe Starting mysqld daemon with databases from /app/mysql
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
140508 14:15:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140508 14:15:19 InnoDB: The InnoDB memory heap is disabled
140508 14:15:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins

这个时候需要检查basedir和datadir。配置的值得和初始化时的值一致。

因而，若要修改datadir的值，则需要重新初始化数据库：

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/app/mysql

使用innodb对于日志的基本配置：

innodb_data_home_dir = /app/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /app/mysql