Access denied for user 'root'@'localhost' (using password: YES)
来源:互联网 发布:sql unique 约束 编辑:程序博客网 时间:2024/06/06 17:26
Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
第一次安装好mysql,然后建表、插入数据后启动项目总是报这个错,乍一看是密码不对。
其实大多数是由于权限不足,不能访问
核对数据库连接配置信息,ip、端口、数据库、用户、密码都正确
那就是权限不足了。
授所有权:
grant all privileges on database.* to user@'%' Identified by 'password' WITH GRANT OPTION;(其他ip访问)
grant all privileges on database.* to user@'localhost' Identified by 'password' WITH GRANT OPTION;(本机访问)
授部分权:
grant select,update on database.* to user@'%' Identified by 'password' WITH GRANT OPTION;(其他ip访问)
grant select,update on database.* to user@'localhost' Identified by 'password' WITH GRANT OPTION;(本机访问)
然后commit;-->flush privileger;
权限查看:
show grants for root@'localhost';--本地访问权限
show grants for root@'%'; --异地访问权限
查看用户密码及权限
select user,host,password from mysql.user; --对应用户
| user | host | password |
+--------+-----------+-------------------------------------------+
| root | localhost | *47A134ED6131CCF8FC128DB676DC495F24CA5EB2 |
+--------+-----------+-------------------------------------------+
select * from mysql.db; --对应权限
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delet
e_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | A
lter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_v
iew_priv | Create_routine_priv | Alter_routine_priv | Execute_priv |
| % | database | user | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y
| Y | Y | Y |
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES) 问题解决
- 解决'Access denied for user 'root'@'localhost' (using password: YES)'
- access denied for user 'root'@'localhost' using password yes
- access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- Access denied for user 'root'@'localhost' (using password: YES)解决办法
- Access denied for user: 'root@localhost' (Using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password:YES) 解决方案
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password:YES)
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- MySql Access denied for user 'root'@'localhost' (using password: YES)
- Spatial pyramid pooling (SPP)-net (空间金字塔池化)笔记
- Apache的在线升级
- echarts实现双y轴,并实现不同的参数使用不同的y轴
- 判断是否IE浏览器
- Android入门:ContentProvider
- Access denied for user 'root'@'localhost' (using password: YES)
- 数据库操作
- 09年的博文,读起来还是有感触的
- n枚硬币找出假币问题(包含一枚假币)
- stl源码剖析 第四章vector实现
- cookie编程
- vsftpd添加用户并限制目录
- vs环境下C++dll生成和使用(基础篇)
- 创始人重返Twitter帮助CEO多西塑造企业文化!