1吃媒、mysql官網(wǎng)下載 https://dev.mysql.com/downloads/mysql/(社區(qū)版x86)
2烙如、安裝的時(shí)候步驟沒(méi)有Configuration,可能是mysql版本和Mac版本不匹配,找下歷史版本試下
Configuration選擇“傳統(tǒng)加密”
3苹祟、配置環(huán)境變量
$vim ./.bash_profile
#添加mysql環(huán)境變量
export PATH=${PATH}:/usr/local/mysql/bin
4砸抛、進(jìn)入數(shù)據(jù)庫(kù)(需要輸入安裝時(shí)設(shè)置的密碼)
$mysql -u root -p
6、進(jìn)入mysql之后重置密碼為root
$set password = "root";
7树枫、查看當(dāng)前數(shù)據(jù)編碼格式
$mysql -u root -p
$show variables like '%char%';
正常會(huì)出現(xiàn)
+--------------------------+-----------------------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql