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

推荐订阅源

WordPress大学
WordPress大学
The GitHub Blog
The GitHub Blog
F
Fortinet All Blogs
Cloudbric
Cloudbric
P
Palo Alto Networks Blog
T
Threatpost
T
Tor Project blog
T
Tenable Blog
AWS News Blog
AWS News Blog
Project Zero
Project Zero
L
LangChain Blog
Cyberwarzone
Cyberwarzone
Engineering at Meta
Engineering at Meta
雷峰网
雷峰网
C
CERT Recently Published Vulnerability Notes
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Security Latest
Security Latest
云风的 BLOG
云风的 BLOG
I
Intezer
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
P
Proofpoint News Feed
A
Arctic Wolf
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
Google DeepMind News
Google DeepMind News
V
Vulnerabilities – Threatpost
C
Cybersecurity and Infrastructure Security Agency CISA
MongoDB | Blog
MongoDB | Blog
aimingoo的专栏
aimingoo的专栏
K
Kaspersky official blog
Jina AI
Jina AI
N
News | PayPal Newsroom
T
The Blog of Author Tim Ferriss
D
DataBreaches.Net
A
About on SuperTechFans
博客园 - 三生石上(FineUI控件)
博客园 - 【当耐特】
Hugging Face - Blog
Hugging Face - Blog
Recorded Future
Recorded Future
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
S
Secure Thoughts
TaoSecurity Blog
TaoSecurity Blog
P
Privacy & Cybersecurity Law Blog
P
Proofpoint News Feed
MyScale Blog
MyScale Blog
IT之家
IT之家
Forbes - Security
Forbes - Security
The Hacker News
The Hacker News
Last Week in AI
Last Week in AI
T
Threat Research - Cisco Blogs
Y
Y Combinator Blog

Mysql - 标签 - cywhat's blog

Linux忘记mysql密码解决办法 Failing Package Is: Mysql Community Libs Compat 5.7.37 1.el7 Django连接Mysql配置 Mysql连接以及增删改查语句 Centos7安装mysql5.7.41亲测可用
Mac安装mysql5.7
cywhat · 2022-04-24 · via Mysql - 标签 - 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 '新密码';   #即可用客户端连接

关注一下再走吧

公众号 小程序

赞赏支持

微信打赏 支付宝打赏