Created
March 10, 2018 00:56
-
-
Save kenmori/cabba441b96b617ed9cc340174f56068 to your computer and use it in GitHub Desktop.
/usr/local/etc/my.cnfがなければこれを追加すでにあれば[client]のところだけ追加
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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] | |
default-character-set = utf8 | |
host = 127.0.0.1 | |
[mysqld] | |
default-character-set = utf8 | |
skip-character-set-client-handshake | |
character-set-server = utf8 | |
collation-server = utf8_general_ci | |
init-connect = SET NAMES 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 = ..... | |
# datadir = ..... | |
# port = ..... | |
# server_id = ..... | |
# socket = ..... | |
# 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment