Please read "Security" section of the manual to find out how to run mysqld a

1 启动：

# mysqld restart
170109 19:30:58 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

170109 19:30:58 [ERROR] Aborting

170109 19:30:58 [Note] mysqld: Shutdown complete

# mysqld start
170109 19:31:12 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

170109 19:31:12 [ERROR] Aborting

170109 19:31:12 [Note] mysqld: Shutdown complete

2 查看了一下错误日志

cat /export/data/mysql/log/error.log


InnoDB: the log sequence number in the ib_logfiles!
170109 20:41:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1 of name './test/monitor.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1 of name './josl/application.ibd' already exists in the tablespace
InnoDB: memory cache!
170109 20:41:10 mysqld_safe mysqld from pid file /export/data/mysql/data/mysql.pid ended


将/export/data/mysql/data/test全部移走，初步认定，数据文件有问题，

3 再进行启动
# sudo -u root mysqld_safe
170109 20:44:58 mysqld_safe Logging to '/export/data/mysql/log/error.log'.
170109 20:44:58 mysqld_safe Starting mysqld daemon with databases from /export/data/mysql/data
170109 20:45:13 mysqld_safe mysqld from pid file /export/data/mysql/data/mysql.pid ended
# sudo -u root mysqld_safe
170109 20:50:20 mysqld_safe Logging to '/export/data/mysql/log/error.log'.
170109 20:50:20 mysqld_safe Starting mysqld daemon with databases from /export/data/mysql/data


或者

4 安全模式启动

sudo -u mysql /export/servers/mysql/bin/mysqld_safe --defaults-file=/export/servers/mysql/etc/my.cnf