注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

good luck guys

welcome

 
 
 

日志

 
 

ERROR 1045 (28000): Access denied for 报错解决办法  

2011-08-29 17:04:29|  分类: 默认分类 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
rpm安装完毕后,直接用
/usr/bin/mysqladmin -u root password newpasswd”修改密码后出现
 
错误信息。
解释:YES,说明密码没有问题。可能是限制不让在本地登陆。于是实用
添加 -h 61.139.xx.252绕过本地测试,也未成功
[root@fms1 ok]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@fms1 ok]# mysql -h 61.139.xx.252 -u root -p
Enter password:
ERROR 1130 (00000): Host '61.139.76.252' is not allowed to connect to this MySQL server
注释: 1130报错信息说明不允许远程访问。没有给该用户授权
然后重新修改密码后可以正常访问:
 
[root@fms1 ok]# /etc/init.d/mysql stop
Shutting down MySQL.[确定]
[root@fms1 ok]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 6699
[root@fms1 ok]# mysql -u root mysql
.......
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
.............................
.............................
.............................
| user                      |
+---------------------------+
17 rows in set (0.00 sec)
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
注:到此修改密码完成。
[root@fms1 ok]# killall -9 mysqld
[root@fms1 ok]# /etc/init.d/mysql start
Starting MySQL[确定]
[root@fms1 ok]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.45-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY "newpasswd";  #用于给用户授权。
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set user="newname" where user="root"; #改名
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
支持完成了修改密码,授权,改名的工作。
[root@fms1 ok]# mysql -u centos -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.45-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
错误信息没有了。
 
总结:
错误提示:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解决方法:1

方法一:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
完成。
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)



引文来源  ERROR 1045 (28000): Access denied for 报错解决办法
  评论这张
 
阅读(548)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017