用服务的方式启动mysql失败

新安装的数据库用shutown关闭后用启动服务的方式无法启动
[root@msyqlzhu tmp]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
[root@msyqlzhu tmp]# /etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

用命令的方式能启动
[root@msyqlzhu tmp]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &
[1] 6108
[root@msyqlzhu tmp]# 2018-11-25T13:09:30.674116Z mysqld_safe Logging to ‘/mysqldata/mysql/data/error.log’.
2018-11-25T13:09:30.700574Z mysqld_safe Starting mysqld daemon with databases from /mysqldata/mysql/data

如果用命令启动了mysql,用服务的方式无法关闭
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]# ps -ef|grep mysql
root 6108 2118 0 08:09 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf
mysql 6536 6108 7 08:09 pts/0 00:00:01 /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/mysqldata/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=msyqlzhu.pid --socket=/mysqldata/mysql/data/mysql.sock --port=3306
root 6565 2414 0 08:09 pts/1 00:00:00 tail -100f /mysqldata/mysql/data/error.log
root 6567 2118 0 08:09 pts/0 00:00:00 grep mysql
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]# service mysqld stop
Stopping mysqld: [ OK ]
[root@msyqlzhu tmp]# ps -ef|grep mysql
root 6108 2118 0 08:09 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf
mysql 6536 6108 4 08:09 pts/0 00:00:01 /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/mysqldata/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=msyqlzhu.pid --socket=/mysqldata/mysql/data/mysql.sock --port=3306
root 6565 2414 0 08:09 pts/1 00:00:00 tail -100f /mysqldata/mysql/data/error.log
root 6601 2118 0 08:10 pts/0 00:00:00 grep mysql
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]# ps -ef|grep mysql
root 6108 2118 0 08:09 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf
mysql 6536 6108 2 08:09 pts/0 00:00:01 /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/mysqldata/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=msyqlzhu.pid --socket=/mysqldata/mysql/data/mysql.sock --port=3306
root 6565 2414 0 08:09 pts/1 00:00:00 tail -100f /mysqldata/mysql/data/error.log
root 6635 2118 0 08:10 pts/0 00:00:00 grep mysql

这时候用mysqladmin的shudown的方式可以关闭
[root@msyqlzhu tmp]# mysqladmin -uroot -pORACLE shutdown
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
[root@msyqlzhu tmp]# 2018-11-25T13:11:50.631122Z mysqld_safe mysqld from pid file /mysqldata/mysql/data/msyqlzhu.pid ended

[1]+ Done /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]#
[root@msyqlzhu tmp]# ps -ef|grep mysql
root 6565 2414 0 08:09 pts/1 00:00:00 tail -100f /mysqldata/mysql/data/error.log
root 6653 2118 0 08:11 pts/0 00:00:00 grep mysql
[root@msyqlzhu tmp]#

最后找到原因是没有添加mysql服务的原因，添加服务后正常使用服务的方式去关闭和启动mysql了
[root@msyqlzhu tmp]# cd /usr/local/mysql/support-files
[root@msyqlzhu support-files]# cp mysql.server /etc/init.d/mysqld
cp: overwrite `/etc/init.d/mysqld’? y
[root@msyqlzhu support-files]# service mysqld start
Starting MySQL…[ OK ]
[root@msyqlzhu support-files]#
[root@msyqlzhu support-files]#
[root@msyqlzhu support-files]# ps -ef|grep mysql
root 6565 2414 0 08:09 pts/1 00:00:00 tail -100f /mysqldata/mysql/data/error.log
root 6748 1 0 08:18 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/mysqldata/mysql/data --pid-file=/mysqldata/mysql/data/msyqlzhu.pid
mysql 7203 6748 19 08:18 pts/0 00:00:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mysqldata/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=error.log --pid-file=/mysqldata/mysql/data/msyqlzhu.pid --socket=/mysqldata/mysql/data/mysql.sock --port=3306
root 7239 2118 0 08:18 pts/0 00:00:00 grep mysql
[root@msyqlzhu support-files]#
[root@msyqlzhu support-files]#
[root@msyqlzhu support-files]# service mysqld stop
Shutting down MySQL…[ OK ]
[root@msyqlzhu support-files]# ps -ef|grep mysql
root 6565 2414 0 08:09 pts/1 00:00:00 tail -100f /mysqldata/mysql/data/error.log
root 7273 2118 0 08:18 pts/0 00:00:00 grep mysql
[root@msyqlzhu support-files]#