Note: The content in this article involves modifying NTFS hard drive permissions and configuring security policies. Please make sure that you understand the possible consequences of the operation before performing any modifications. All the permissions mentioned in this document are attached to the original permissions. [Modification steps] 1. Create a user named mysqlusr and configure a random password. The password length is the best.
Note: The content in this article involves modifying NTFS hard drive permissions and configuring security policies. Please make sure that you understand the possible consequences of the operation before performing any modifications. All the permissions mentioned in this document are attached to the original permissions. [Modification steps] 1. Create a user named mysqlusr and configure a random password. The password length is the best.
Note: The content in this article involves modifying NTFS hard drive permissions and configuring security policies. Please make sure that you understand the possible consequences of the operation before performing any modifications.
All the permissions mentioned in this document are attached to the original permissions.
[Modification steps]
1. Create a user
Create a user named mysqlusr and configure a random password. The password length is the best.
No less than 20 characters.
2. Configure the user's identity
Add the mysqlusr user to the Guests group and remove any other group.
3. Configure hard disk Permissions
Assume that MySQL is installed in the following directory:
D: \ hosting \ system \ mysql \
Assume that MySQL Data Inventory is stored in the following directory:
D: \ hosting \ MySQLDB \
Assume that the MySQL service provider is changed to mysqlusr.
The directory permission configuration is as follows:
D: \ hosting \ system \ mysql \
Mysqlusr
Read and run
List folder Directories
Read
D: \ hosting \ system \ mysql \ tmpdir
Mysqlusr
Modify
Read and run
List folder Directories
Read
Write
D: \ hosting \ MySQLDB \
Mysqlusr
Modify
Read and run
List folder Directories
Read
Write
4. Modify the corresponding configuration of MySQL
Modify my. ini in the MySQL directory
Add a row as follows:
Tmpdir = D:/hosting/system/MySQL/tmpdir
