Windows下安装多个MYSQL
作者:[网上资料 ]
D:\MySQL5.5\bin>mysqld --install mysql --defaults-file="D:/MySQL5.5/d_base/my.ini"
[client]
port=3007
[mysql]
#default-character-set=utf8
[mysqld]
port=3007
basedir="D:/MySQL5.5/"
datadir="D:/MySQL5.5/data/"
default-storage-engine=MYISAM
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=3000
query_cache_size=128M
tmp_table_size=128M
thread_cache_size=32
thread_concurrency = 16
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 8M
myisam_max_sort_file_size=10G
myisam_sort_buffer_size=128M
|
[client]
port=3007
[mysql]
#default-character-set=utf8
[mysqld]
port=3007
basedir="D:/MySQL5.5/"
datadir="D:/MySQL5.5/data/"
default-storage-engine=MYISAM
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=3000
query_cache_size=128M
tmp_table_size=128M
thread_cache_size=32
thread_concurrency = 16
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 8M
myisam_max_sort_file_size=10G
myisam_sort_buffer_size=128M
|