Copy Code code as follows:
Unzip MySQL to d:\mysql, 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=16m
max_allowed_packet=1m
table_cache=128
Thread_cache=8
join_buffer_size=512k
sort_buffer=512k
record_buffer=512k
max_connections=500
wait_timeout=120
interactive_timeout=120
max_connect_errors=3000
Long_query_time=1
max_heap_table_size=16m
Tmp_table_size=8m
Thread_concurrency=8
Myisam_sort_buffer_size=8m
myisam_sort_buffer_size=4m
Low_priority_updates=1
Ft_min_word_len=1
Edit two batches
Installation
D:
CD D:\mysql\bin
Mysqld-nt.exe--install MySQL--defaults-file=d:\mysql\my.ini
net start MySQL
Pause
Unloading
D:
CD D:\APM\mysql\bin
net stop MySQL
Mysqld-nt.exe--remove MySQL
Pause
Copy Code code as follows:
Add a MySQL startup user, set this user as the guest group,
Set the D:\mysql directory to the Administrators group, system, and new user full permissions.
Set up the MySQL service startup account for the new user and restart the MySQL service.
Settings Deny local login.
