Skip to content

Instantly share code, notes, and snippets.

@daijinload
Last active July 9, 2017 11:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save daijinload/d6016e006acc43039a5ecc45a11b0136 to your computer and use it in GitHub Desktop.
Save daijinload/d6016e006acc43039a5ecc45a11b0136 to your computer and use it in GitHub Desktop.
Windowsでmysql5.7をzipインストールする ref: http://qiita.com/daijinload/items/cf3e2e548f5008973140
[mysqld]
# dirs
basedir="C:/mysql"
datadir="C:/mysql/data"
tmpdir = "C:/mysql/temp"
# logging
log_output=TABLE,FILE
log_error_verbosity=3
log_error="C:/mysql/logs/mysqld_error.log"
general_log=1
general_log_file="C:/mysql/logs/general_query_all.log"
log-slow-admin-statements=1
log-queries-not-using-indexes=1
slow_query_log=1
long_query_time=1
slow_query_log_file="C:/mysql/logs/slow_query.log"
log_syslog=0
log_timestamps=SYSTEM
[mysql]
default_character_set=utf8
default-time-zone="+9:00"
rem path設定はこの手順では必要ないですが、やるとしたらこんな感じです。
rem SET PATH=%PATH%;C:\mysql\bin
rem 初期化(失敗してやり直すときは、dataフォルダを消したほうがよい。)
C:\mysql\bin\mysqld --initialize-insecure --user=mysql
rem 起動
C:\mysql\bin\mysqld --defaults-file="C:\mysql\my.ini" --console
rem 中に入る。(パスワードは無し。後で、設定したほうが良いかと)
c:\mysql\bin\mysql -u root -p
rem シャットダウン
Ctrl + C
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment