springboot连接数据出现Access denied for user 'root'@'localhost' (using password: YES)

[five is me.]

数据库密码都正确，同样的代码 第二台电脑跑的起来，这个电脑跑不起来

Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userController': Unsatisfied dependency expressed through field 'userService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userServiceImpl': Unsatisfied dependency expressed through field 'userMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userMapper' defined in file [D:\chyx\chuhui\ch-user\service\target\classes\com\wyqf365\user\mapper\UserMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail ! Cause:java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

[家有娇妻张兔兔]

检查下yml的配置文件是否正确，看下数据库是否授权

[a1767028198]

debug数据源实例化的过程，去看看到底密码是什么

[韩_师兄]

root用户没有权限,在mysql里面先给权限就好了

[Java全栈路线]

数据库权限的问题，得进mysql里面开启权限

use mysql;
grant all on *.* to 'root'@'%' with grant option;
flush privileges;

[狂奔的蜗牛已被占用]

我之前也遇到过类似的问题，就是代码都没问题；重建一个项目，完全一摸一样的代码就能跑起来；

[Little BigUs]

root 用户没有访问权限

[five is me.]

引用 1 楼 Little BigUs 的回复：

root 用户没有访问权限

有本地的访问权限，刚看过

[雨润泽林]

看这篇文章，最后有解决方案：https://blog.csdn.net/qq_17555933/article/details/117229900?spm=1001.2014.3001.5501

[无聊啊无聊啊啊啊啊啊啊]

[冰思雨]

你连接的是本地数据库。问题出在本地数据库上面。

第二台的数据库，与当前这台机器的数据库，配置不相同。

正如楼上几位说的，把 root 的本地访问权限添加一下试试。

或者，你是不是要连接同一个数据库啊？ 如果是的话，更改一下 localhost ，把地址改到目标主机，并且添加 root 的访问权限。