[{"createTime":1735734952000,"id":1,"img":"hwy_ms_500_252.jpeg","link":"https://activity.huaweicloud.com/cps.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=V1g3MDY4NTY=&utm_medium=cps&utm_campaign=201905","name":"华为云秒杀","status":9,"txt":"华为云38元秒杀","type":1,"updateTime":1735747411000,"userId":3},{"createTime":1736173885000,"id":2,"img":"txy_480_300.png","link":"https://cloud.tencent.com/act/cps/redirect?redirect=1077&cps_key=edb15096bfff75effaaa8c8bb66138bd&from=console","name":"腾讯云秒杀","status":9,"txt":"腾讯云限量秒杀","type":1,"updateTime":1736173885000,"userId":3},{"createTime":1736177492000,"id":3,"img":"aly_251_140.png","link":"https://www.aliyun.com/minisite/goods?userCode=pwp8kmv3","memo":"","name":"阿里云","status":9,"txt":"阿里云2折起","type":1,"updateTime":1736177492000,"userId":3},{"createTime":1735660800000,"id":4,"img":"vultr_560_300.png","link":"https://www.vultr.com/?ref=9603742-8H","name":"Vultr","status":9,"txt":"Vultr送$100","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":5,"img":"jdy_663_320.jpg","link":"https://3.cn/2ay1-e5t","name":"京东云","status":9,"txt":"京东云特惠专区","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":6,"img":"new_ads.png","link":"https://www.iodraw.com/ads","name":"发布广告","status":9,"txt":"发布广告","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":7,"img":"yun_910_50.png","link":"https://activity.huaweicloud.com/discount_area_v5/index.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=aXhpYW95YW5nOA===&utm_medium=cps&utm_campaign=201905","name":"底部","status":9,"txt":"高性能云服务器2折起","type":2,"updateTime":1735660800000,"userId":3}]
这句话翻译过来的意思是“没有权限,但使用的密码是对的”
我遇到这个问题的时候,看了很多的都是老版本的解决方案,都是更改my.ini下的[mysqld]下一行直接增加skip-grant-tables,就可以实现跳过输入密码,但是对于现在最新的、高版本的mysql,已经不能继续采取这样的方法了。
具体实现的步骤如下所示
一.停止服务
在终端中直接输入net stop mysql,也可以在此电脑中,服务中停止mysql服务
net stop mysql
二.跳过密码
进入mysql目录中bin文件夹下,启动终端,使用mysqld -console --skip-grant-tables --shared-memory
mysqld -console --skip-grant-tables --shared-memory
输入完后发现没有反应,不要着急,输入以下代码
mysqld --console --skip-grant-tables --shared-memory
mysqld --console --skip-grant-tables --shared-memory
三.观察数据
输入完成后,就会得到如下的数据,这下就可以无密码登录mysql了
这时候需要在bin目录下在打开一个终端,输入mysql -u root -p,输入密码时直接回车,就直接进去了
进去之后,需要将密码更改
直接进入主题!
1.输入 use mysql;
2.清空root 密码 UPDATE user SET authentication_string="" WHERE user=“root”;
3.刷新权限 flush privileges;
注意:第3步务必要做!
四.启动服务
在启动前,将前两个cmd终端关了
在进入一次bin目录下
输入net start mysql,成功启动服务
成功启动服务器后
五.登录MySQL
在bin目录下,打开终端,输入mysql -u root -p 要输入密码的时候,直接回车,就进入mysql了,并且密码为空