[ERROR] Failed to execute/usr/local/mysql/bin/mysqld --bootstrap --datadir=……

一：问题描述

今天在建库时报错:

[root@PC lib64]# /usr/local/mysql/bin/mysql_install_db--user=mysql --basedir=/usr/local/mysql --datadir=/data/server/mysql_3307/data
2015-12-30 03:48:39 [WARNING] mysql_install_db isdeprecated. Please consider switching to mysqld --initialize
2015-12-30 03:48:39 [ERROR]   Child process:/usr/local/mysql/bin/mysqldterminated prematurely with errno= 32
2015-12-30 03:48:39 [ERROR]   Failed to execute/usr/local/mysql/bin/mysqld --bootstrap --datadir=/data/server/mysql_3307/data--lc-messages-dir=/usr/local/mysql/share --lc-messages=en_US--basedir=/usr/local/mysql

二：出错原因

mysql 5.7不支持mysql_install_db，应该使用mysqld --initialize 完成实例初始化。

三：解决办法

/usr/local/mysql/bin/mysqld --defaults-file=/data/server/mysql_3307/my.cnf --user=mysql --basedir=/usr/local/mysql --datadir=/data/server/mysql_3307/data --initialize 

本篇文章主要参考：http://tieba.baidu.com/p/3881791613