MySQL Security Settings graphic tutorial

CopyCode The Code is as follows: Decompress MySQL to D: \ mysql and edit my. ini.

[Mysqld]
Port = 3306
Basedir = "D:/MySQL /"
Datadir = "D:/MySQL/data /"
Tmpdir = "D:/MySQL/tmp /"
Default-character-set = utf8
Default-storage-engine = MyISAM
Skip-bdb
Skip-InnoDB
Skip-locking

Key_buffer = 16 m
Max_allowed_packet = 1 m
Table_cache = 128
Thread_cache = 8
Join_buffer_size = 512 K
Sort_buffer = 512 K
Record_buffer = 512 K
Max_connections = 500
Wait_timeout = 120
Interactive_timeout = 120
Max_connect_errorrs = 3000
Long_query_time = 1
Max_heap_table_size = 16 m
Tmp_table_size = 8 m
Thread_concurrency = 8
Myisam_sort_buffer_size = 8 m
Myisam_sort_buffer_size = 4 m
Low_priority_updates = 1
Ft_min_word_len = 1
Edit two batches
Install
D:
Cd d: \ mysql \ bin
Mysqld-nt.exe -- install MySQL -- defaults-file = D: \ mysql \ My. ini
Net start MySQL
Pause
Uninstall
D:
Cd d: \ APM \ mysql \ bin
Net stop MySQL
Mysqld-nt.exe -- remove MySQL
Pause

Copy codeThe Code is as follows: add a MySQL startup user and set this user as the guest group,
Set D: \ mysql directory to full permissions for the Administrators group, system, and newly added users.
Set the MySQL Service Startup account as a newly added user and restart the MySQL service.
Set to reject local login.