yowrhihoil 2016-12-01 07:16 采纳率: 50%
浏览 3693
已采纳

为什么mysql5.6没有my.ini配置文件

我是到官网下的5.6zip windows版本,只有一个my-default.ini
内容那个也很简单

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 = C:\Program Files\MySQL\MySQL Server 5.6
datadir = C:\Program Files\MySQL\MySQL Server 5.6\data

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

  • 写回答

1条回答 默认 最新

  • oyljerry 2016-12-01 13:45
    关注

    把这个文件改名就行了,然后可以修改它添加设置

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?