How to assign permissions to mysql in win System
How to assign permissions to mysql in win System
Create user
Create a user named mysqlusr and set a random password. The password length is the best.
No less than 20 characters.
2. Set the user's identity
Add the mysqlusr user to the Guests group and remove any other group.
3. Set disk Permissions
Assume that MySQL is installed in the following directory:
D: hostingsystemmysql
Assume that MySQL Data Inventory is stored in the following directory:
D: hostingMySQLDB
Assume that the MySQL service provider is changed to mysqlusr.
The directory permission settings are as follows:
D: hostingsystemmysql
Mysqlusr
Read and run
List folder Directories
Read
D: hostingsystemmysqltmpdir
Mysqlusr
Modify
Read and run
List folder Directories
Read
Write
D: hostingMySQLDB
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 line as follows:
Tmpdir = D:/hosting/system/MySQL/tmpdir