MySQL Security Settings graphic tutorial

Copy codeThe 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 a 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.