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
Suppose MySQL is installed in the following directory
D:hostingsystemmysql
Suppose the MySQL database is stored in the following directory
D:hostingmysqldb
Suppose MySQL's service performer modifies to MYSQLUSR
The directory permissions are set as follows
D:hostingsystemmysql
Mysqlusr
Read and run
Listing folder directories
Read
D:hostingsystemmysqltmpdir
Mysqlusr
Modify
Read and run
Listing folder directories
Read
Write
D:hostingmysqldb
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