mysql5.6.23winx64.zip 설치 세부사항

SET MYSQL_HOME=D:\mysql-5.6.23-winx64
SET PATH=%PATH%;%MYSQL_HOME%\bin

[mysqld]
loose-default-character-set = utf8 
basedir = D:/mysql-5.6.23-winx64
datadir = D:/mysql-5.6.23-winx64/data
port = 13306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
character_set_server = utf8
[client]  
loose-default-character-set = utf8

C:\> "D:\mysql-5.6.23-winx64\bin\mysqld" --install MySQL --defaults-file=C:\my-opts.cnf

C:\Users\tanw>"D:\mysql-5.6.23-winx64\bin\mysqld" --install MySQL56
Service successfully installed.

mysql -u root -P 13306
mysql>UPDATE mysql.user SET Password = password ( 'root' ) WHERE User = 'root' ;
mysql>FLUSH  PRIVILEGES;
mysql>exit

mysql -u root -p -P 13306
Enter Password: ****
mysql>