Set MySQL security permissions under Windows

Note: The content of this article involves modifying NTFS disk permissions and setting security policies, and make sure that you understand the possible consequences of the operation before you make any changes.

Note: The content of this article involves modifying NTFS disk permissions and setting security policies, and make sure that you understand the possible consequences of the operation before you make any changes.
The permissions mentioned in this article are those that are attached to the original permission.

[Modify Step]
1. Create a user
Create a user named Mysqlusr, set a random password, the length of the password is the best
Do not have less than 20 digits.

2. Set the user's identity
Add MYSQLUSR users to the Guests group and remove any other groups.

3. Set disk Permissions
AssumeMySQLInstalled in the following directory
D:\hosting\system\mysql\

Suppose MySQL'sDatabasestored in the following directory
D:\hosting\MySQLDB\

Suppose MySQL's service performer modifies to MYSQLUSR

The directory permissions are set as follows
D:\hosting\system\mysql\
Mysqlusr
Read and run
Listing folder directories
Read

D:\hosting\system\mysql\tmpdir
Mysqlusr
Modify
Read and run
Listing folder directories
Read
Write

D:\hosting\MySQLDB\
Mysqlusr
Modify
Read and run
Listing folder directories
Read
Write

4. Modify the appropriate configuration of MySQL
Modify the My.ini under the MySQL directory
Add one line to the following
Tmpdir=d:/hosting/system/mysql/tmpdir