インストールメモ

MySQL インストール

https://dev.mysql.com/downloads
mysql-8.0.12-winx64.zip


Dドライブに解凍

D:\mysql-8.0.12-winx64


ディレクトリ作成

D:\mysql-8.0.12-winx64\data
D:\mysql-8.0.12-winx64\logs
D:\mysql-8.0.12-winx64\tmp


my.ini作成

D:\mysql-8.0.12-winx64\my.ini

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
character-set-server=utf8
basedir = D:/mysql-8.0.12-winx64
datadir = D:/mysql-8.0.12-winx64/data
tmpdir = D:/mysql-8.0.12-winx64/tmp

## logging
general_log = 1
general_log_file = D:/mysql-8.0.12-winx64/logs/general_query_all.log
log_error = D:/mysql-8.0.12-winx64/logs/mysqld_error.log
log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_syslog = 0
log_timestamps = SYSTEM
long_query_time = 3
slow_query_log = 1
slow_query_log_file = D:/mysql-8.0.12-winx64/logs/slow_query.log


環境変数の設定

Path に追加 D:\mysql-8.0.12-winx64\bin


データディレクトリの初期化

mysqld --defaults-file=D:\mysql-8.0.12-winx64\my.ini --initialize

logs/mysqld_error.log にrootの初期パスワードが出力されるのでメモる
2018-08-22T09:26:53.667278+09:00 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 初期パスワード


起動

mysqld --defaults-file=D:\mysql-8.0.12-winx64\my.ini --console


接続

mysql -u root -p


rootのパスワード変更

ALTER USER 'root'@'localhost' IDENTIFIED BY '新しいパスワード';


文字コード確認

show variables like "char%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

停止

mysqladmin -u root -p shutdown