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