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

推荐订阅源

S
Schneier on Security
有赞技术团队
有赞技术团队
T
The Blog of Author Tim Ferriss
F
Fortinet All Blogs
D
DataBreaches.Net
F
Full Disclosure
腾讯CDC
博客园 - 【当耐特】
MyScale Blog
MyScale Blog
Stack Overflow Blog
Stack Overflow Blog
小众软件
小众软件
Hugging Face - Blog
Hugging Face - Blog
Last Week in AI
Last Week in AI
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
爱范儿
爱范儿
The GitHub Blog
The GitHub Blog
Engineering at Meta
Engineering at Meta
大猫的无限游戏
大猫的无限游戏
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
S
SegmentFault 最新的问题
The Register - Security
The Register - Security
WordPress大学
WordPress大学
博客园 - 聂微东
雷峰网
雷峰网
J
Java Code Geeks
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
P
Privacy International News Feed
酷 壳 – CoolShell
酷 壳 – CoolShell
A
Arctic Wolf
Scott Helme
Scott Helme
C
Cyber Attacks, Cyber Crime and Cyber Security
T
Tor Project blog
博客园 - 三生石上(FineUI控件)
Know Your Adversary
Know Your Adversary
AWS News Blog
AWS News Blog
G
Google Developers Blog
www.infosecurity-magazine.com
www.infosecurity-magazine.com
C
CERT Recently Published Vulnerability Notes
O
OpenAI News
Project Zero
Project Zero
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
Application and Cybersecurity Blog
Application and Cybersecurity Blog
云风的 BLOG
云风的 BLOG
N
News and Events Feed by Topic
MongoDB | Blog
MongoDB | Blog
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Microsoft Security Blog
Microsoft Security Blog
Cisco Talos Blog
Cisco Talos Blog
P
Palo Alto Networks Blog
Schneier on Security
Schneier on Security

Mac - 分类 - cywhat's blog

Mac修改brew源 Mac出现xxx@bogon Zsh Problem Compinit503 No Such File or Directory Usr Local Share Zsh Site Mac必备软件推荐 Mac忽略系统更新提醒,并取消小红点 Mac安装brew
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 '新密码';   #即可用客户端连接

关注一下再走吧

公众号 小程序

赞赏支持

微信打赏 支付宝打赏