Why should the MySQL database have to run in the "normal user" state? As with MSSQL server, because if you use the "Super administrator" or "Local System user" to run the "MySQL database", it will be exploited by hackers, using system user rights to invade the server. Therefore, in order to server security, be sure to run MySQL in the "normal user" state. At the same time, to the hard disk permissions to do the appropriate permissions to set up MySQL to normal operation.
Establish common users;
Click Start-Administrative Tools-Computer Management to enter the Computer Management interface.
Click "System Tools"-"Local Users and Groups"-"Users" to enter user management;
Right-click on user, select New user, add new user;
Enter new user to establish the interface;
Enter MySQL to run the user "Mysqlrun" and set the password, click "Create" to establish the user;
Open the security properties of the MySQL installation packing directory (right-click on the installation disk letter, select Properties, click the Security tab in the Pop-up property box).
Click Add, enter the MySQL run user "Mysqlrun" in "Select User or group", click OK to add user to 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 settings, and exit;
Enter the MySQL installation directory, the same in the folder right select "Properties";
Open the MySQL installation directory properties of the "security" attribute, delete the "SYSTEM" user, add "mysqlrun" user, permissions for full control;
After setting the permissions of the directory, you need to set the running user of MySQL to Mysqlrun;
Click "This account" to set up an account;
Click "Browse" to enter the MySQL user "Mysqlrun" in the input box;
Enter the password for the Mysqlrun user in the password and Confirm password, click "Apply" and the System pop-up Service Warning window "The new logon name will not take effect until you stop and restart the service." , click OK.
At this point restart the service, MySQL is running under the mysqlrun of this ordinary user, server security will be greatly enhanced.
Running MySQL under ordinary users (if you need to quote or reprint this article, please specify the author: Poly Friends, Source: http://www.juyo.org)
