在线等待,求解:Access denied for user 'root'@'localhost' (using password: YES)

2008-05-13 05:36:05 1.6万阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

解决：Access denied for user ‘root‘@‘localhost‘ (using password: YES) 文章目录Xshell 命令访问MySQL数据库，密码连接报错！一、报错截图示下：二、分析：三、解决方案：3.1. Windows系统：3.2. Linux 系统 Xshell 命令访问MySQL数据库，密码连接报错！报错内容：Access denied for user 'root'@'localhost' (using password: YES) 在MySQL登录时出现Access denied for user 'root'@'localhost' (using password: YE 阅读详情

2008-05-13 15:36:44,658 WARN (SettingsFactory.java:117) - Could not obtain connection metadata
java.sql.SQLException: Server connection failure during transaction.
Due to underlying exception: 'java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)'.
-----------------------------------------------------------------------------------------------------

是Linux+Tomcat+MySQL部署程序.
客户端可以访问数据库,
自己写的程序也可以查询数据库,
root用户权限都给了,但不能获得数据库连接,以下是部署文件内容:
<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

<property name="driverClassName" value="com.mysql.jdbc.Driver" />

<property name="url" value="jdbc:mysql://localhost:3306/workplat?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8" />

<property name="username" value="root" />

<property name="password" value="1" />

</bean>

...全文

龙头复盘神器/复盘于导出工具最新版5.6 龙头复盘神器，复盘于导出工具阅读详情

it_radhat

MySQL 57,062 成员 56,759 内容

+ 关注 + 加入社区

切换为时间正序

furong_123 2010-03-10

打赏
举报

我也遇到了同样的问题
我也是按照你的方法
但是没有重新分配权限

String url ="jdbc:mysql://localhost/first";
Connection conn= DriverManager.getConnection(url,"root","lsg123");

//first 是我的数据库名称，url为数据库的地址，root为MySQL数据库登陆的用户名，lsg123为密码，密码就是你登陆mysql控制台的密码

这样就可以了

双子涂鸦 2008-11-15

打赏
举报

今天终于找到了解决办法：
打开"MySQL Server Instance Config Wizard" (开始/程序/mysql一直找下去)
走到用户密码设置的时候不要在复选Enable root access from remote machines

然后再一直走下去
当然其他各步设置请与以前的配置保持一致,不要简单地按下next

做完之后
mysql控制台,进行重新分配权限操作

mysql>Grant all on *.* to 'root'@"%" identified by "xxxx" with grant option;

终于
一切都好用了

双子涂鸦 2008-11-13

打赏
举报

这个问题同样困扰着我
帮顶

yoyoo1625 2008-11-04

打赏
举报

GRANT ALL PRIVILEGES ON *.* TO mysql@'192.168.70.%' IDENTIFIED BY '123456' WITH GRANT OPTION;

it_radhat 2008-05-23

打赏
举报

用FLUSH PRIVILEGES过了,还是不行啊!

skyqiang 2008-05-23

打赏
举报

[Quote=引用 11 楼 yueliangdao0608 的回复:]
value="jdbc:mysql://localhost:3306/workplat?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8" />

mysql> SELECT user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
¦ user ¦ host ¦ password ¦
+------+-----------+-------------------------------------------+
¦ hb ¦ % …
[/Quote]

懒得去死 2008-05-17

打赏
举报

FLUSH PRIVILEGES。

it_radhat 2008-05-16

打赏
举报

utpcb 2008-05-16

打赏
举报

加入一条
user 为root HOST为LOCALHOST的

懒得去死 2008-05-16

打赏
举报

value="jdbc:mysql://localhost:3306/workplat?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8" />

mysql> SELECT user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
¦ user ¦ host ¦ password ¦
+------+-----------+-------------------------------------------+
¦ hb ¦ % ¦ *E6CC90B878B948C35E92B003C792C46C58C4AF40 ¦
¦ root ¦ % ¦ *E6CC90B878B948C35E92B003C792C46C58C4AF40 ¦
¦ plat ¦ % ¦ *4070D183DE69A1433F9FD15CCF82D2643C084A18 ¦
¦ b ¦ localhost ¦ *F33AE6DD04EF4C7C1D3105568E7FB7C1EE16C937 ¦
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql>
没有看到你的user 为root HOST为LOCALHOST的

it_radhat 2008-05-16

打赏
举报

请大家帮忙看看阿,这是user表里的用户:
密码,权限都有了,为何访问被拒绝.

2008-05-13 14:56:56,467 WARN (SettingsFactory.java:117) - Could not obtain connection metadata
java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)'.

mysql> SELECT user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| hb | % | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| root | % | *E6CC90B878B948C35E92B003C792C46C58C4AF40 |
| plat | % | *4070D183DE69A1433F9FD15CCF82D2643C084A18 |
| b | localhost | *F33AE6DD04EF4C7C1D3105568E7FB7C1EE16C937 |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql>

懒得去死 2008-05-15

打赏
举报

[Quote=引用 7 楼 it_radhat 的回复:]
google了下,有人说是root权限的问题,可是我在客户端可以查询数据

麻烦下,谁能告诉我怎么开放linux下mysql,root@localhost全部权限.
[/Quote]

大家的回复你仔细研究一下不就搞定了？

it_radhat 2008-05-14

打赏
举报

谢谢!
我是用的SQLYog远程连接MYSQL服务器
客户端是可以连接上,密码可以肯定是正确的,

但修改数据时不能获得连接, 访问否认为用户‘root'@'localhost’使用密码。

权限都给了,不知道是什么原因!请指导!

懒得去死 2008-05-14

打赏
举报

看我发的精华帖

http://topic.csdn.net/u/20071229/09/a0c7e024-0293-4e7a-9454-ba412f94d99d.html

it_radhat 2008-05-14

打赏
举报

google了下,有人说是root权限的问题,可是我在客户端可以查询数据

麻烦下,谁能告诉我怎么开放linux下mysql,root@localhost全部权限.

liuyann 2008-05-13

打赏
举报

http://blog.chinaunix.net/u1/35320/showart_305024.html

试试这里介绍的方法。

==== 思想重于技巧 ====

reply via CSDN viewer

it_radhat 2008-05-13

打赏
举报

谢谢!确认授权了,但还是不行.

[root@hubing ~]# su - mysql
-bash-3.00$ mysql -u root -p
Enter password: 1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.41-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on *.* to root@"%" Identified by "1";
Query OK, 0 rows affected (0.00 sec)

mysql>

liuyann 2008-05-13

打赏
举报

没有给你的root授权.

mysql> GRANT ALL ON *.* TO root@'%';

==== 思想重于技巧 ====

reply via CSDN viewer

在线等待,求解:Access denied for user 'root'@'localhost' (using password: YES)

相关推荐