mysqld--safe operation with normal account

Source: Internet
Author: User
Tags mssql server

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.