windows(64) install mysql

今天尝试安装了一下mysql，真心费劲，特整理如下

1.download

地址 百度软件中心 mysql64位 for windows

2.unzip file and config my.ini, following

[client]
port=3306
default-character-set=utf8

# #客户端字符类型，与服务端一致就行，建议utf8

[mysqld]
port=3306
character_set_server=utf8

# #服务端字符类型，建议utf8

basedir=D:\dev\db\mysql-5.6.24-winx64

# #解压根目录

datadir=D:\dev\db\mysql-5.6.24-winx64\data

# #解压根目录\data

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

3.must

• must open cmd with administor

• must cd mysql\bin\

  mysqld -install
  net start mysql