惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

S
Secure Thoughts
罗磊的独立博客
T
The Blog of Author Tim Ferriss
人人都是产品经理
人人都是产品经理
博客园 - 叶小钗
Last Week in AI
Last Week in AI
美团技术团队
Google Online Security Blog
Google Online Security Blog
Application and Cybersecurity Blog
Application and Cybersecurity Blog
D
Docker
G
Google Developers Blog
大猫的无限游戏
大猫的无限游戏
酷 壳 – CoolShell
酷 壳 – CoolShell
小众软件
小众软件
月光博客
月光博客
L
LINUX DO - 最新话题
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
W
WeLiveSecurity
H
Heimdal Security Blog
Vercel News
Vercel News
SecWiki News
SecWiki News
Forbes - Security
Forbes - Security
Blog — PlanetScale
Blog — PlanetScale
Google DeepMind News
Google DeepMind News
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
www.infosecurity-magazine.com
www.infosecurity-magazine.com
TaoSecurity Blog
TaoSecurity Blog
T
Troy Hunt's Blog
A
About on SuperTechFans
C
Check Point Blog
S
Security Affairs
Hacker News - Newest:
Hacker News - Newest: "LLM"
AI
AI
WordPress大学
WordPress大学
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
Help Net Security
Help Net Security
博客园_首页
The Last Watchdog
The Last Watchdog
S
SegmentFault 最新的问题
Hugging Face - Blog
Hugging Face - Blog
Security Archives - TechRepublic
Security Archives - TechRepublic
Engineering at Meta
Engineering at Meta
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
I
Intezer
K
Kaspersky official blog
M
MIT News - Artificial intelligence
J
Java Code Geeks
G
GRAHAM CLULEY
P
Palo Alto Networks Blog

Mac - 标签 - cywhat's blog

Mac修改brew源 Mac出现xxx@bogon Mac必备软件推荐 Mac忽略系统更新提醒,并取消小红点 Mac安装brew Iterm2/Mac自带终端工具快速ssh
Mac安装mysql5.7
cywhat · 2022-04-24 · via Mac - 标签 - cywhat's blog

1.下载Dmg安装包

安装包下载

我选择的Mysql版本是5.7.30

/img/img55.png

2.安装并启动

/img/img56.png

/img/img57.png

3.记录Mysql初始密码

/img/img58.png

4.设置别名

1
2
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin

5.重置密码

1
2
3
mysqladmin -u root -p password `新密码`   #回车后输入临时密码

mysql -u root -p  #输入新密码即可命令行登录

6.本地Navicat客户端登录

连接不上(报错): 2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(

原因:

由于从mysql5.7版本之后 验证方式默认从原来的mysql_native_password改成了caching_sha2_password

解决:

1
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';   #即可用客户端连接

关注一下再走吧

公众号 小程序

赞赏支持

微信打赏 支付宝打赏