首先前往http://www.mysql.com/downloads/mysql/下载mysql
一路安装，安装完成后，
重启mysql-server
sudo /usr/local/mysql/support-files/mysql.server restart
添加快捷命令，用mysql代替/usr/local/mysql/bin/mysql
vi ~/.bash_profile
#添加的内容
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
#生效
source ~/.bash_profile
修改密码
mysql -u root -p
默认密码为空
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
修改默认字符集为utf8
5.6版本：
sudo /usr/local/mysql/my.cnf
5.7版本：
sudo vi /etc/my.cnf
新建或打开的文件中，添加或修改为以下内容
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
重启mysql-server
sudo /usr/local/mysql/support-files/mysql.server restart
mysql -u root -p
输入密码后进入控制台
show variables like '%char%';
成功：
image.png
进一步测试：
创建数据库
mysql>create database taomiao
#切换到项目数据库
use taomiao
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';
image.png
查看编码，完全统一了。
mysql5.7要去掉ONLY_FULL_GROUP_BY
[mysqld]下添加
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
重启mysql-server
sudo /usr/local/mysql/support-files/mysql.server restart
进入mysql查询
show variables like "sql_mode";
注意：
my.cnf里面的参数要填正确，否则启动mysql会出现以下提示：
Starting MySQL
. ERROR! The server quit without updating PID file
如图：
image.png
