数据库无法启动

问答中心分类: Linux数据库无法启动
xiaoqingxu asked 8 年 ago
<img src="http://i3.piimg.com/0bca25b7afea6e29.png"/>
 
/usr/local/mysql/bin/mysqld start
2016-04-21 09:43:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-21 09:43:27 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.30) starting as process 5591 ...
2016-04-21 09:43:27 5591 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2016-04-21 09:43:27 5591 [ERROR] Aborting

2016-04-21 09:43:27 5591 [Note] Binlog end
2016-04-21 09:43:27 5591 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

3 Answers
xiaoqingxu answered 8 年 ago
[root@888 ~]# cd /usr/local/mysql/bin
[root@888 bin]# chmod 755 mysqld
[root@888 bin]# service mysqld start
mysqld: unrecognized service
[root@888 bin]# chown mysql:mysql mysql
[root@888 bin]# /usr/local/mysql/bin/mysqld start
2016-04-21 09:43:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-21 09:43:27 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.30) starting as process 5591 ...
2016-04-21 09:43:27 5591 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2016-04-21 09:43:27 5591 [ERROR] Aborting

2016-04-21 09:43:27 5591 [Note] Binlog end
2016-04-21 09:43:27 5591 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

xiaoqingxu answered 8 年 ago
[root@888 ~]# cd /usr/local/mysql/bin
[root@888 bin]# chmod 755 mysqld
[root@888 bin]# service mysqld start
mysqld: unrecognized service
[root@888 bin]# chown mysql:mysql mysql
[root@888 bin]# /usr/local/mysql/bin/mysqld start
2016-04-21 09:43:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-21 09:43:27 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.30) starting as process 5591 ...
2016-04-21 09:43:27 5591 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2016-04-21 09:43:27 5591 [ERROR] Aborting

2016-04-21 09:43:27 5591 [Note] Binlog end
2016-04-21 09:43:27 5591 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

oneinstack answered 8 年 ago
不能用root用户启动mysqld,请执行service mysqld  start