python踩坑记录，mac端（持续更新）

# 安装完成之后打开“系统便好设置”，最底下有Mysql，点开，点击启动mysql服务。
# 打开终端

open -e ~/.bash_profile 

# 在打开的记事本文件中滑到最下面加入

export PATH=${PATH}:/usr/local/mysql/bin

# 保存关闭，然后在终端输入

source ~/.bash_profile

# 上面的操作主要是为了加全局命令指向，接着便可以登录mysql了，打开终端输入
mysql -u root -p
# 输入初始密码，就是安装过程中输入的密码

SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘新密码‘);

# 上面这句是基于登录mysql成功后的修改密码
# 有可能会遇到报错：mysql Client does not support authentication protocol requested by server; consider upgrading MySQL
# 解决方法
ALTER USER ‘root@localhost’ IDENTIFIED BY ‘123456’
# ---------------------------------

# navicat链接报错  Client does not support authentication protocol requested by server; consider upgrading MySQL client
# 解决方法：

ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘你的密码‘;
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘你的密码‘;
SELECT plugin FROM mysql.user WHERE User = ‘root‘;