• 周二. 6月 25th, 2024

5G编程聚合网

5G时代下一个聚合的编程学习网

热门标签

1045 access denied for user 'root'@'localhost' using password yes

admin

11月 28, 2021

1. 开始 –> cmd   –> net stop mysql  (停用MySQL服务  没启动的可以省略)

2. 找到安装路径 MySQL Server 5.1下的my.ini

3. 打开 my.ini  找到  [mysqld]  然后在下面加上

     这句: skip_grant_tables (意思好像是 启动MySQL服务的时候跳过权限表认证  )

4. 然后就启动数据库修改密码了   

    开始 –> cmd   –>   net start mysql   (启动MySQL服务)—>  cd D:xamppmysqlin

5. 输入use mysql; (连接权限数据库)。

6. 改密码:update user set password=password(“123″) where user=”root”;(别忘了最后加分号) 。

7. 刷新权限(必须步骤):flush privileges; 。 

8. 退出 quit。 

9. 将第3 步的 my.ini里的 skip_grant_tables  去掉(启动MySQL服务的时候不能让他跳过权限表认证 )

10. 重启MySQL ,再进入,使用用户名root和刚才设置的新密码123就可以登录了。 

 来源:http://bbs.csdn.NET/topics/310006640   

《1045 access denied for user 'root'@'localhost' using password yes》有2个想法
  1. Fast Lean Pro is a herbal supplement that tricks your brain into imagining that you’re fasting and helps you maintain a healthy weight no matter when or what you eat. It offers a novel approach to reducing fat accumulation and promoting long-term weight management. https://fastleanprobuynow.us/

  2. Wow, wonderful weblog structure! How lengthy have you ever been running a blog for?
    you made blogging glance easy. The total glance of your site is magnificent, as neatly as the content material!
    You can see similar here najlepszy sklep

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注