首先前往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
#添加的內(nèi)容
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
#生效
source ~/.bash_profile
修改密碼
mysql -u root -p
默認(rèn)密碼為空
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
修改默認(rèn)字符集為utf8
5.6版本：
sudo /usr/local/mysql/my.cnf
5.7版本：
sudo vi /etc/my.cnf
新建或打開的文件中米丘，添加或修改為以下內(nèi)容
[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
輸入密碼后進(jìn)入控制臺(tái)
show variables like '%char%';
成功：
image.png
進(jìn)一步測試：
創(chuàng)建數(shù)據(jù)庫
mysql>create database taomiao
#切換到項(xiàng)目數(shù)據(jù)庫
use taomiao
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';
image.png
查看編碼名段，完全統(tǒng)一了躏惋。
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
進(jìn)入mysql查詢
show variables like "sql_mode";
注意：
my.cnf里面的參數(shù)要填正確，否則啟動(dòng)mysql會(huì)出現(xiàn)以下提示：
Starting MySQL
. ERROR! The server quit without updating PID file
如圖：
image.png
