/var/log/mysql.err1710119:42:53[Note]Plugin'FEDERATED'isdisabled.1710119:42:53InnoDB:TheInnoDBmemoryheapisdisabled1710119:42:53InnoDB:Mutexesandrw_locksuseGCCatomicbuilti...
/var/log/mysql.err
171011 9:42:53 [Note] Plugin 'FEDERATED' is disabled.
171011 9:42:53 InnoDB: The InnoDB memory heap is disabled
171011 9:42:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171011 9:42:53 InnoDB: Compressed tables use zlib 1.2.3
171011 9:42:53 InnoDB: Using Linux native AIO
171011 9:42:53 InnoDB: Initializing buffer pool, size = 2.9G
171011 9:42:54 InnoDB: Completed initialization of buffer pool
171011 9:42:54 InnoDB: highest supported file format is Barracuda.
171011 9:42:55 InnoDB: Waiting for the background threads to start
171011 9:42:56 InnoDB: 5.5.57 started; log sequence number 1595675
171011 9:42:56 [ERROR] /usr/sbin/mysqld: unknown option '--risks'
171011 9:42:56 [ERROR] Aborting
171011 9:42:56 InnoDB: Starting shutdown...
171011 9:42:57 InnoDB: Shutdown completed; log sequence number 1595675
171011 9:42:57 [Note] /usr/sbin/mysqld: Shutdown complete
systemctl status mysql.service
[root@localhost test]# systemctl status mysql.service
● mysql.service - LSB: start and stop MySQL
Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
Active: failed (Result: exit-code) since Wed 2017-10-11 09:42:58 CST; 10min ago
Docs: man:systemd-sysv-generator(8)
Process: 851 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=1/FAILURE)
Oct 11 09:42:51 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...
Oct 11 09:42:58 localhost.localdomain mysql[851]: Starting MySQL...... ERROR! The server quit without updating PID file (/var/lib/mysql/mysqld.pid).
Oct 11 09:42:58 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=1
Oct 11 09:42:58 localhost.localdomain systemd[1]: Failed to start LSB: start and stop MySQL.
Oct 11 09:42:58 localhost.localdomain systemd[1]: Unit mysql.service entered failed state.
Oct 11 09:42:58 localhost.localdomain systemd[1]: mysql.service failed.
手动创建PID并指明PID号 后可以运行 运行后pid 文件被自动删除了 然后restart 又是这个问题了 问题扎到了 我my.cnf 里有几行错了 谢谢了 !
展开