本地安装MYSQL80,spring连接报错

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
The error may exist in file [D:\chatroom2\WebChat-master\target\webchat\WEB-INF\classes\com\amayadream\webchat\mapping\UserMapper.xml]
The error may involve com.amayadream.webchat.dao.IUserDao.selectUserByUserid
The error occurred while executing a query
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
.......
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
....

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

java.lang.NullPointerException
com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:3299)
com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1967)
com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1893)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1287)

遇到过相同问题，推荐参考：https://blog.csdn.net/weixin_42683679/article/details/81428591

其他的查询是正确的吗？如果其他的查询是正确的，那就不是数据库连接的问题，如果其他的也不行，那就从数据库配置，数据源配置入手吧

Could not get JDBC Connection无法或取jdbc连接，看下jdbc的用户名密码啥的配的还对

发一下你的数据库配置代码

无法连接的原因是mysql8与mysql5的加密方式不同。
更改加密方式：
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
执行后：
Query OK, 0 rows affected (0.10 sec)
更改密码：
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
执行后：
Query OK, 0 rows affected (0.35 sec)

刷新