mysql settings

[windows] copy my-default.ini C:\Windows\my.ini
[linux] $ cp my-default.cnf /etc/my.cnf)

$ vi my.cnf

[mysql]
default-character-set=utf8

[mysqld]
character-set-server=utf8

---

[注]
1. delete default mysql56 service under dos

sc delete mysql56

2. install mysql service

C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin\mysqld –install

Mac init password

$ cd /usr/local/mysql/bin
$ sudo su
$ ./mysqld_safe --skip-grant-tables &

$ ./mysql
mysql> FLUSH PRIVILEGES;
# since 5.7
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
# before 5.7
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');