mysql 安装版 解压班_教你安装Mysql(解压版/非安装包)图文教程 r囧r小猫 2022-11-05 03:07 185阅读 0赞 该楼层疑似违规已被系统折叠 隐藏此楼查看此楼 my-default 的文件内容: \# For advice on how to change settings please see \# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html \# \*\*\* DO NOT EDIT THIS FILE. It's a template which will be copied to the \# \*\*\* default location during install, and will be replaced if you \# \*\*\* upgrade to a newer version of MySQL. \[mysqld\] \# Remove leading \# and set to the amount of RAM for the most important data \# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. \# innodb\_buffer\_pool\_size = 128M \# Remove leading \# to turn on a very important data integrity option: logging \# changes to the binary log between backups. \# log\_bin \# These are commonly set, remove the \# and set as required. \# basedir = ..... \# datadir = ..... \# port = ..... \# server\_id = ..... \# Remove leading \# to set options mainly useful for reporting servers. \# The server defaults are faster for transactions and fast SELECTs. \# Adjust sizes as needed, experiment to find the optimal values. \# join\_buffer\_size = 128M \# sort\_buffer\_size = 2M \# read\_rnd\_buffer\_size = 2M sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES //===================修改后====================== \# For advice on how to change settings please see \# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html \# \*\*\* DO NOT EDIT THIS FILE. It's a template which will be copied to the \# \*\*\* default location during install, and will be replaced if you \# \*\*\* upgrade to a newer version of MySQL. \[client\] port=3306 default-character-set=utf8 \[mysqld\] port=3306 character\_set\_server=utf8 \# Remove leading \# and set to the amount of RAM for the most important data \# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. \# innodb\_buffer\_pool\_size = 128M \# Remove leading \# to turn on a very important data integrity option: logging \# changes to the binary log between backups. \# log\_bin \# These are commonly set, remove the \# and set as required. basedir = D:\\Program Files\\MySQL\\mysql-5.6.25-winx64 datadir = D:\\Program Files\\MySQL\\mysql-5.6.25-winx64\\data \# port = ..... server\_id = mysql \# Remove leading \# to set options mainly useful for reporting servers. \# The server defaults are faster for transactions and fast SELECTs. \# Adjust sizes as needed, experiment to find the optimal values. \# join\_buffer\_size = 128M \# sort\_buffer\_size = 2M \# read\_rnd\_buffer\_size = 2M sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES \[WinMySQLAdmin\] D:\\Program Files\\MySQL\\mysql-5.6.25-winx64\\bin\\mysqld.exe
还没有评论,来说两句吧...