1.安裝
brew install mysql
2. 配置
mysql服務(wù)設(shè)置為開機(jī)自動(dòng)啟動(dòng)
brew services start mysql
關(guān)閉mysql服務(wù)
brew services stop mysql
重啟mysql服務(wù)
brew services restart mysql
查看mysql服務(wù)狀態(tài)
brew services list
3. 設(shè)置root密碼
mysql_secure_installation
設(shè)置步驟
a)為root用戶設(shè)置密碼
b)刪除匿名賬號(hào)
c)取消root用戶遠(yuǎn)程登錄
d)刪除test庫和對(duì)test庫的訪問權(quán)限
e)刷新授權(quán)表使修改生效
4. navicat連接
連接報(bào)錯(cuò)，執(zhí)行如下命令
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密碼';
SELECT plugin FROM mysql.user WHERE User = 'root';
5. mysql導(dǎo)入數(shù)據(jù)報(bào)錯(cuò)
錯(cuò)誤：ERROR 2006 (HY000): MySQL server has gone away
修改max_allowed_packet值
show variables like 'max_allowed_packet';
set global max_allowed_packet = 1048576000;
