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 |