首先前往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