MySQL security settings graphic tutorial bitsCN.com
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
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.
BitsCN.com
