Why do I have to run the MySQL database in a "normal user" state? Like MSSQL server, because if you use "Super Administrator" or "Local System user" to run "MySQL database", it will be exploited by hackers, with system user rights to invade the server. Therefore, for server security, be sure to run MySQL in the "normal user" state. At the same time, to the permissions of the hard disk to do the corresponding permissions set MySQL to run properly.
1. Establishment of ordinary users;
Go to the Computer Management interface (click Start-Administrative Tools-Computer Management), click System Tools-Local Users and groups-users, right-click on users, select New user, add new user;
Enter the new user Setup interface:
Enter MySQL to run the user "Mysqlrun" and set the password, click "Create" to establish the user;
Add user to Guest group
2. Set permissions for the MySQL directory
2.1 Open the security properties of the MySQL installation packing directory (right-click on the installation disk letter, select "Properties" and click on the "Security" tab in the Pop-up properties box).
Click Add, enter the MySQL run user "Mysqlrun" that you just added in the "Select User or group" and click OK to add the user to the MySQL installation packing directory;
Set the permissions of the "Mysqlrun" user, cancel the default read and run permissions, leave the Read and List folder directories permissions, click OK, save the setting and exit;
2.2. Go to the MySQL installation directory and right-click the folder to select "Properties";
Open the "Security" property of MySQL installation directory properties, delete "SYSTEM" user, add "mysqlrun" user, the permission is Full control;
Note: I installed MySQL is 5.6, there are two directories must be user name permission settings
(1)
(2)
3. Set the running user of MySQL to Mysqlrun;
Click the properties of the MySQL service, select login, click "This Account", set up the account;
Click "Browse" to enter the MySQL user "Mysqlrun" in the input box;
Enter the password of the Mysqlrun user in the password and Confirm password, click "Apply", the system pops up the service Warning window "The new login will only take effect if you stop and restart the service." , click OK.
Restart the service at this time, MySQL is running under the ordinary user Mysqlrun, the server security will be greatly enhanced.
mysqld--safe operation with normal account