运行java文件时,报错:Access denied for user ‘root’@‘localhost’ (using password: YES)
13:04:10.715 [C3P0PooledConnectionPoolManager[identityToken->1hge43cab1p0ka1k1e26dhn|e4487af]-HelperThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
从Access denied for user ‘root’@‘localhost’ (using password: YES)看,是root用户访问被拒绝。网上有很多改密码的帖子,越改越乱,简单粗暴把MYSQL卸载重装,重装过程中密码设置一定要设置成:含有大小写字母且大于8位的,否则都不生效,导致无法正常登陆。
密码设置合规后,再打开sequel pro连接本地mysql就连接成功啦!