MySql (22) - Linux MySQL Startup Problems ( SERS) Fatal Error: "Security" section of the to find out
1399 人阅读 | 时间：2019年10月17日 09:53
去获取百度分享代码
Source: https://www.cnblogs.com/abclife/p/5052997.html
(ERROR) Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
When testing mysqld to start mysql server, the following error was reported:
2015-12-17 00:46:02 10785 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 2015-12-17 00:46:02 10785 [ERROR] Aborting 2015-12-17 00:46:02 10785 [Note] Binlog end2015-12-17 00:46:02 10785 [Note] ./mysqld: Shutdown complete
Reason:
This is because root is used to start during testing. From a security perspective, it is not recommended to start with root users.
Solution:
1. When using root user startup, bring -user -root, force dying (not recommended, only test)
# ./mysqld --user=root &# ps -ef|grep mysql | grep -v grep root 11055 11019 0 01:02 pts/0 00:00:00 ./mysqld --user=root
2. At startup time, specify mysql user
# ./mysqld --user=mysql &# ps -ef|grep mysql |grep -v grep mysql 11165 11100 2 01:06 pts/1 00:00:00 ./mysqld --user=mysql
3. Designate users at my.cnf
[mysqld] user=mysql
©著作权归作者所有：来自ZhiKuGroup博客作者没文化的原创作品，如需转载，请注明出处，否则将追究法律责任
来源：ZhiKuGroup博客，欢迎分享。
评论专区