Last active
July 9, 2017 11:08
-
-
Save daijinload/d6016e006acc43039a5ecc45a11b0136 to your computer and use it in GitHub Desktop.
Windowsでmysql5.7をzipインストールする ref: http://qiita.com/daijinload/items/cf3e2e548f5008973140
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
[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" |
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
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 | |
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
rem シャットダウン | |
Ctrl + C |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment