启动数据库报错
[root@datanode4 mysql]# /etc/init.d/mysqld start Starting MySQL.. ERROR! The server quit without updating PID file (/data/mysql/mysql-pid/mysql-pid).
日志当中报错
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
经过查阅资料得知。这个是初始化的路径找不到了,我修改了my.cnf文件。
重新进行初始化。
[root@datanode4 mysql]# /usr/local/mysql/scripts/mysql_install_db Installing MySQL system tables...2017-06-15 21:06:39 0 [Note] ./bin/mysqld (mysqld 5.6.26-log) starting as process 27818 ... OK Filling help tables...2017-06-15 21:06:42 0 [Note] ./bin/mysqld (mysqld 5.6.26-log) starting as process 27842 ... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system ........
[root@datanode4 mysql]# /etc/init.d/mysqld start Starting MySQL. SUCCESS!
好了,现在启动正常了。