:与不通用
都使用了IIS7,使用及安装的方法几乎一致,但因为微软的老毛病,系统不同的情况下,Bug也会不同,这里大叔记录了一些安装其他系统时遇到一些情况记录。
的文件,各个系统之间不能通用,所以在安装时,无法直接把的直接移植过去,大叔就重写了就可以正常使用了。
[WinMySQLAdmin]
Server=C:/Users/Administrator/***/***/***/mysql-5.7.16/bin/mysqld.exe
[client]
no-beep
#pipe
#socket=mysql
port=3306
[mysql]
default-character-set=utf8
#Foradviceonhowtochangesettingspleasesee
#http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
#***DONOTEDITTHISFILE.Itsatemplatewhichwillbecopiedtothe
#***defaultlocationduringinstall,andwillbereplacedifyou
#***upgradetoanewerversionofMySQL.
[mysqld]
explicit_defaults_for_timestamp=TRUE
#Removeleading#andsettotheamountofRAMforthemostimportantdata
#cacheinMySQL.Startat70%oftotalRAMfordedicatedserver,else10%.
innodb_buffer_pool_size=2G
#Removeleading#toturnonaveryimportantdataintegrityoption:logging
#changestothebinarylogbetweenbackups.
#log_bin
#Thesearecommonlyset,removethe#andsetasrequired.
#basedir=C:\mysql-5.7.11-win32\
basedir=C:\Users\Administrator\***\***\***\mysql-5.7.16\
#datadir=C:\mysql-5.7.11-win32\data\
datadir=C:\Users\Administrator\***\***\***\mysql-5.7.16\data\
port=3306
server_id=1
general-log=0
general_log_file=mysql_general.log
slow-query-log=1
slow_query_log_file=mysql_slow_query.log
long_query_time=10
log-error=mysql_error_log.err
default-storage-engine=INNODB
max_connections=1024
query_cache_size=128M
key_buffer_size=128M
innodb_flush_log_at_trx_commit=1
innodb_thread_concurrency=128
innodb_autoextend_increment=128M
tmp_table_size=128M
#Removeleading#tosetoptionsmainlyusefulforreportingservers.
#TheserverdefaultsarefasterfortransactionsandfastSELECTs.
#Adjustsizesasneeded,experimenttofindtheoptimalvalues.
#join_buffer_size=128M
#sort_buffer_size=2M
#read_rnd_buffer_size=2M
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
character-set-server=utf8
innodb_flush_method=normal
/pre