MySQL登录时出现的Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) 的解决办法
来源:互联网 发布:网络信息工程师 编辑:程序博客网 时间:2024/06/05 00:33
第一次使用IP登录MySQL时会出现的问题
问题过程:
:~$mysql -h xxx.xxx.xxx.xxx -u root -p
Enter password:
ERROE 1045 (28000): Access denied for user ‘root’@’xxx.xxx.xxx.xxx’ (using password: YES)
原因:
没有对其进行授权
解决方法:
1.用localhost登录
:~$mysql -u root -p
Enter password:
2.授权
mysql> grant all privileges on . to root@’%’ identified by ‘123’;
Query OK, 0 rows affected (0.34 sec)
3.退出
mysql> quit
Bye
4.用IP登录
:~$ mysql -h xxx.xxx.xxx.xxx -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 112787
Server version: 5.5.54-0ubuntu0.12.04.1 (Ubuntu)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
解决问题
- MySQL登录时出现的Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) 的解决办法
- MySQL登录时出现 Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) 的原因及解决办法
- 关于用jdbc访问云数据库mysql Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)问题
- Access denied for user 'xxx'@'localhost.localdomain' (using password: YES))
- ERROR 1045 (28000)- Access denied for user 'xxx'@'localhost' (using password- YES)【奇葩的bug】
- linux下安装mysql后Access denied for user 'xxx'@'xxxxx' (using password: YES)
- mysql Access denied for user root@localhost 后出现找不到数据库下的表XXX
- 关于在使用spring出现类似java.sql.SQLException: Access denied for user 'XXX'@'localhost' (using password: YES)
- java.sql.SQLException: Access denied for user 'XXX'@'localhost' (using password: YES)
- 解决Cannot create PoolableConnectionFactory (Access denied for user 'xxx'@'xxx.xxx.xx.xxx' (using pas
- java.sql.SQLException: Access denied for user 'root'@'xxx.xxx.xxx.xxx' at (数据库名)
- 使用dbcp出现 Access denied for user 'root'@'localhost' (using password:YES) 的解决办法
- MySQL Access denied for user 'root'@'%' to database 'xxx'
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”)的处理方法
- mysql中Access denied for user 'root'@'localhost' (using password:YES)的解决办法(本人实操)
- 冒泡排序逻辑
- 设计模式(四)——JDK中的那些工厂方法
- [数学模型]商人怎样安全过河
- 在网上书城项目中对数据库连接错误的解决
- Java并发编程(一)--AbstractQueuedSynchronizer
- MySQL登录时出现的Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) 的解决办法
- 使用spring4.3.7整合hibernate4.2.21异常处理
- 通过百度地图API获取地址经纬度
- oracle11g 将某个用户下的数据导出成.bmp格式的文件,并将该文件导入到另一个库中
- andorid 微信 分享开发以及解决分享闪退问题
- 【知了堂学习笔记】利用ajax实现web中的批量删除
- new和delete,malloc和free 转自http://www.kuqin.com/effectivec2e/ch01a.htm
- 我的互联网价值观、方法论和个人实践(4)-个人信用模型
- struts2获取前台传递过来的数据的三种方式