数据库Error 1045(28000) Access Denied for user 'root'@'localhost' 错误
来源:互联网 发布:mac如何彻底关闭程序 编辑:程序博客网 时间:2024/09/21 08:53
在windows操作系统安装mysql数据库,碰到Error 1045(28000) Access Denied for user 'root'@'localhost' 错误时,需要重新设置密码。
具体方法是:1.先在安装目录找到my.ini配置文件,打开配置文件,找到[mysqld]一行,在下面添加skip-grant-tables后保存该文件,重新启mysql动服务。
2.然后在cmd执行 mysql -u root mysql
mysql>update user set password=password('newpassword') where user='root';
mysql>Flush privileges;
其中newpassword为root的新密码。
3.将刚才my.ini配置文件的添加那一行去掉,最后重新启动mysql就可以了。
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' 错误
- 数据库Error 1045(28000) Access Denied for user 'root'@'localhost' 错误
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL Error 1045(28000) Access Denied for user 'root'@'localhost'
- Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ERROR 1045 (28000): Access denied for user'root'@'localhost'
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)错误解决方法
- MyBatisMap传入数据错误解决
- kmp算法
- libnet编译,windows/Linux
- Poj 1635 Subway tree systems (树的最小表示)
- Android的init过程详解
- 数据库Error 1045(28000) Access Denied for user 'root'@'localhost' 错误
- 简单有效-禁止其他人到你电脑上用QQ
- 动态的获取和设置ImageView的宽度和高度
- linux下的二进制工具(反编译工具)
- ios UIImageView 中的image显示部分
- mac如何共享文件
- gassion永刚
- hdu1013-Digital Roots
- 反编译APK系列之dx的使用