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

推荐订阅源

博客园_首页
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
P
Proofpoint News Feed
G
Google Developers Blog
B
Blog
Engineering at Meta
Engineering at Meta
阮一峰的网络日志
阮一峰的网络日志
The Register - Security
The Register - Security
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
博客园 - 叶小钗
The Cloudflare Blog
The Hacker News
The Hacker News
D
Darknet – Hacking Tools, Hacker News & Cyber Security
C
CXSECURITY Database RSS Feed - CXSecurity.com
雷峰网
雷峰网
F
Fortinet All Blogs
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
H
Hackread – Cybersecurity News, Data Breaches, AI and More
酷 壳 – CoolShell
酷 壳 – CoolShell
Last Week in AI
Last Week in AI
T
Threat Research - Cisco Blogs
A
About on SuperTechFans
量子位
Recorded Future
Recorded Future
博客园 - 三生石上(FineUI控件)
H
Help Net Security
Help Net Security
Help Net Security
P
Palo Alto Networks Blog
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
T
Troy Hunt's Blog
W
WeLiveSecurity
V
Vulnerabilities – Threatpost
T
The Exploit Database - CXSecurity.com
Know Your Adversary
Know Your Adversary
Apple Machine Learning Research
Apple Machine Learning Research
Scott Helme
Scott Helme
N
News | PayPal Newsroom
AWS News Blog
AWS News Blog
D
DataBreaches.Net
Blog — PlanetScale
Blog — PlanetScale
MongoDB | Blog
MongoDB | Blog
B
Blog RSS Feed
腾讯CDC
J
Java Code Geeks
Microsoft Azure Blog
Microsoft Azure Blog
TaoSecurity Blog
TaoSecurity Blog
GbyAI
GbyAI
Y
Y Combinator Blog
Hacker News - Newest:
Hacker News - Newest: "LLM"
D
Docker

博客园 - darkblue

mysql官方资源 MYSQL时间查询相关 mysql-用户管理 mysql备份还原 水液代谢与五脏调节 津液 献给成长中的孩子们 oracle--v$lock type字段详解 iis日志字段解析 Asp.net Core学习文章 如何让vs2017 EF实体生成支持Mysql 和 Oracle? 连接sqlexpress 阿里云乌班图16配置-PHP环境(包括mysql及apache安装) mysql主从复制跳过错误 64位系统下powerdesigner15连接oracle odbc 解决“指定的服务已经标记为删除”问题 mysql系列-安装及服务启动 数据缓存管理 redis-在乌班图下设置自动启动
mysql-root本地无法登录处理
darkblue · 2017-09-20 · via 博客园 - darkblue

主要有以下几种情况:

1.忘记密码

2.丢失root对localhost的访问权限或者对应的host授权

解决方案:

---------------------------------------------------------------------------------

将mysql启动到无权限校验模式 

net stop mysql
mysqld --defaults-file="my.ini" --console --skip-grant-tables
--启动新的窗口
select Host,user from mysql.user
--使用命令切换到mysql数据库:
use mysql;

------------------如果是密码忘记执行以下命令更改密码---------------------------------
--使用命令更改root密码:
UPDATE user SET Password=PASSWORD('newpassword') where USER='root';

----------------------------------------------------------------------------------------------------

-----------------如果是丢失host授权,执行以下授权命令-------------------------------

---查看host授权情况--

select host,user from user;

---授权--

GRANT ALL PRIVILEGES ON *.* TO 'root'@'相应的主机ip' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;

如: 

   GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;

---------------------------------------------------------------------------------------------------
--刷新权限:
FLUSH PRIVILEGES;
--然后退出,重新登录:
quit