[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 is reported:

2015-12-17 00:46:02 10785 [ERROR] Fatal error:please read "Security" section of the manual-find out how to run mysqld As ROOT!2015-12-17 00:46:02 10785 [ERROR] aborting2015-12-17 00:46:02 10785 [Note] Binlog end2015-12-17 00:46:02 10785 [No TE]./mysqld:shutdown Complete

Reason:

This is because the root is used to start the test. From a security standpoint, it is not recommended to start with the root user.

Solution:

1. When booting with the root user, bring--user=root, Force boot (not recommended, only for testing)

#./mysqld--user=root ps-ef|grep MySQL | Grep-v greproot     11055 11019  0 01:02 pts/0    00:00:00./mysqld--user=root

2. When you start, specify the MySQL user

#./mysqld--user=mysql ps-ef|grep mysql |grep-v grep mysql    11165 11100  2 01:06 pts/1    00:00:00./mysq LD--user=mysql

3. Specify users in MY.CNF

[Mysqld]user=mysql

[ERROR] Fatal error:please read "Security" section of the manual to find out how to run mysqld as root!