Detailed explanation of how to implement MySQL power down operation

If the system user is running MySQL on the server, this is very dangerous. Once Mysql has a vulnerability or is privileged by other modes, it will directly be system permissions. So we need to downgrade MySQL now!

#1. Reduce the rights of MySQL and run it with normal permissions. Assume that (1) mysql is installed in the d:\mysql directory (2) the running user name is mysqluser, so we first need to create a new user, assuming it is "mysqluser"

2. In My Computer → Management → Local Users and Groups→New User→Fill in the username. Select "User cannot change password" and "Password never expires", and cancel the other 2 √

3. Find the one you just created User, right-click properties, modify the user's properties

4. After a new user is created, it will be added to the users component by default. Delete this group and do not join any group. . Clear the group, do not join any group, and click OK.

5. Assume that the MySQL database is installed in d:\mysql, set NTFS permissions on this directory

( 1) Administrators full control

(2)System full control

(3)MysqlUser full control

If there are other permissions, delete all other permissions. The steps are as follows

Modify the NTFS permissions of d:\mysql

6. At this time, the permissions may be continued and may not be deleted, click "Advanced"

7. Cancel permission inheritance

8. Select Copy to copy the inherited permissions from the upper directory

9. After canceling the permission inheritance, you can delete the permission

10. After deletion, only Keep administrators and system, and add the mysqluser user at the same time

11. Select the newly added mysqluser and click Full Control

12. At this time, only 3 users can fully control the d:\mysql directory in this directory, and other users have deleted it

The above is the detailed content of Detailed explanation of how to implement MySQL power down operation. For more information, please follow other related articles on the PHP Chinese website!