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.
The permissions mentioned in the 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 best length of password
not 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
Suppose MySQL is installed in the following directory
D:hostingsystemmysql

Assume that the MySQL database is stored in the following directory
D:hostingmysqldb

Suppose that the MySQL service run is modified to MYSQLUSR

Directory permissions are set as follows
D:hostingsystemmysql
     mysqlusr
          Read and run the
         List folder directory
         Read

D:hostingsystemmysqltmpdir
      MYSQLUSR
         Modify
          Read and run the
         List folder directory
          Read
         write

D:hOstingmysqldb
     mysqlusr
         Modify
         Read and run
         List Folder directory
         read
          Write

4. Modify MySQL's corresponding configuration
modify the MySQL directory of My.ini
in which add a row, the following
Tmpdir=d:/hosting/system/mysql/tmpdir