Home >Database >Mysql Tutorial >Detailed explanation of how to implement MySQL power down operation
Detailed explanation of how to implement MySQL power down operation
- 黄舟Original
- 2017-08-01 11:10:452379browse
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!