ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
来源:互联网 发布:网络签约写手的收入 编辑:程序博客网 时间:2024/06/10 17:30
刚刚在网上看了下由于Linux更新,已经没有完整的更改mysql密码步骤。
我自己总结了一下。
MySQL忘记密码解决办法:
切换到root用户
1.vi/etc/my.cnf
添加 skip-grant-tables,后保存退出。
2.重启数据库systemctl restart mysqld(Linux更新后我这么用,你们随意。)
3.登陆MySQL mysql -uroot -p,密码随便输入。
4.输入USE mysql,回车。
5.输入update mysql.user set authentication_string=password('root') where user='root';,回车。
6.退出数据库\q,编辑vi/etc/my.cnf 删除skip-grant-tables,后保存退出。
7.重启数据库systemctl restart mysqld,密码root生效。
8.改密码有教程就不说了,谢谢。
参考资料:
http://www.cnblogs.com/allenblogs/archive/2010/08/12/1798247.html
http://blog.csdn.net/u010603691/article/details/50379282
阅读全文
1 0
- error: 'Access denied for user 'root'@'localhost' (using password: YES)'
- ERROR 1045 (28000): Access denied for user'root'@'localhost'(using password:YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user’root’@'localhost’(using password:YES)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决办法
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- ERROR 1045 (28000): Access denied for user ’root’@’localhost’ (using password: YES)
- ERROR 1045 (28000): Access denied for user'root'@'localhost'(using password:YES)最近解决方法在!
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- Weird Rounding (Codeforces-779B)
- 为独立服务器安装 Grid Infrastructure
- 解决方法 [ubuntu phpmyadmin 错误提示: 缺少 mcrypt 扩展,请检查 php 配置]
- Safe Or Unsafe(哈夫曼树)
- jQuery关于对表单进行验证和验证码的实现
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- WEB前端开发人员须知的常见浏览器兼容问题及解决技巧
- Python for循环之查找下一个记录
- Android xUtils3源码解析之数据库模块
- Eclipse如何正确的从svn中检出maven项目
- 【原创】Spring-boot快速入门(一)HelloWord!--转载请注明出处
- 0-1背包问题(动态规划)
- Copy Elision
- 计算文件大小