Mysql启动失败

Question

我已经从源代码包安装了mysql-5.6.14

试着开始：

vaio1 1@vaio1-VPCEA3S1E:mysqld

 2013-11-17 13:22:18 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
 2013-11-17 13:22:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
 2013-11-17 13:22:18 1777 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
 2013-11-17 13:22:18 1777 [Warning] One can only use the --user switch if running as root  
 2013-11-17 13:22:18 1777 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
 2013-11-17 13:22:18 1777 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
 2013-11-17 13:22:18 1777 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
 2013-11-17 13:22:18 1777 [Note] Plugin 'FEDERATED' is disabled.mysqld: Unknown error 1146
 2013-11-17 13:22:18 1777 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
 2013-11-17 13:22:18 1777 [Note] InnoDB: The InnoDB memory heap is disabled
 2013-11-17 13:22:18 1777 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 2013-11-17 13:22:18 1777 [Note] InnoDB: Compressed tables use zlib 1.2.3
 2013-11-17 13:22:18 1777 [Note] InnoDB: Using CPU crc32 instructions
 2013-11-17 13:22:18 1777 [Note] InnoDB: Initializing buffer pool, size = 128.0M
 2013-11-17 13:22:18 1777 [Note] InnoDB: Completed initialization of buffer pool
 2013-11-17 13:22:18 1777 [Note] InnoDB: Highest supported file format is Barracuda.
 2013-11-17 13:22:19 1777 [Note] InnoDB: 128 rollback segment(s) are active.
 2013-11-17 13:22:19 1777 [Note] InnoDB: Waiting for purge to start
 2013-11-17 13:22:19 1777 [Note] InnoDB: 5.6.14 started; log sequence number 1600677
 2013-11-17 13:22:19 1777 [ERROR] Aborting

Answer 1

也许，您得到了MySQL 5.6二进制文件，但是my.cnf和数据文件是旧版本。

你读过http://dev.mysql.com/doc/refman/5.6/en/upgrading.html吗？

MySQL死的主要原因是：

Unknown error 1146 2013-11-17 13:22:18 1777 [ERROR] Can't open the mysql.plugin table.
Please run mysql_upgrade to create it

参见手册如何使用mysql_upgrade。大多数错误消息都与不推荐的选项相关。

Answer 2

打开终端并运行以下命令来启动mysql服务：

$ sudo mysqld_safe --skip-grant-tables

在mysql服务运行时，请打开其他终端并运行：

$ sudo mysql_upgrade -u root -p

Answer 3

mysqld reads this standard configuration file and can not read the 5.5 message file in
5.6, leading to this error.

Solutions :

1. pass your configuration file to mysql_install_db

./scripts/mysql_install_db --defaults-file=my.cnf

2. use --no-defaults, not to read other configuration files

./scripts/mysql_install_db --no-defaults --basedir=/home/praveen/mysql-5.6.10-linux-x86_65 
--datadir=/home/praveen/data