springboot jar项目部署linux出现linux用户没有权限的恶心问题

springboot在win10上测试没有问题，打jar包部署linux报错如下，

java.sql.SQLException: Access denied for user 'root'@'slt1ozd5lk9.novalocal' (using password: YES)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.13.jar!/:8.0.13]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.13.jar!/:8.0.13]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.13.jar!/:8.0.13]
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~[mysql-connector-java-8.0.13.jar!/:8.0.13]
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[mysql-connector-java-8.0.13.jar!/:8.0.13]
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[mysql-connector-java-8.0.13.jar!/:8.0.13]
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207) ~[mysql-connector-java-8.0.13.jar!/:8.0.13]
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136) ~[HikariCP-3.2.0.jar!/:na]
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar!/:na]
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar!/:na]
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) [HikariCP-3.2.0.jar!/:na]
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) [HikariCP-3.2.0.jar!/:na]
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.2.0.jar!/:na]
        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.2.0.jar!/:na]
        at com.github.pagehelper.PageHelper.getSqlUtil(PageHelper.java:281) [pagehelper-4.1.0.jar!/:na]
        at com.github.pagehelper.PageHelper.initSqlUtil(PageHelper.java:261) [pagehelper-4.1.0.jar!/:na]
        at com.github.pagehelper.PageHelper.intercept(PageHelper.java:248) [pagehelper-4.1.0.jar!/:na]
        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) [mybatis-3.4.6.jar!/:3.4.6]
        at com.sun.proxy.$Proxy85.query(Unknown Source) [na:na]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) [mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) [mybatis-3.4.6.jar!/:3.4.6]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_191]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_191]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_191]

这一看就是mysql账号没权限，但是问题来了，这特么是我ssh协议登录linux的账号啊，怎么会是这个没权限，没权限也应该是mysql的账号没权限啊。
我在mysql查看用户
SELECT DISTINCT CONCAT(‘User: ‘’’,USER,’’’@’’’,HOST,’’’;’) AS QUERY FROM mysql.user;

springboot jar项目部署linux出现linux用户没有权限的恶心问题
居然还真有这个。那么既然是权限问题，当然是授权了

GRANT ALL PRIVILEGES ON *.* TO [email protected]'slt1ozd5lk9.novalocal' IDENTIFIED BY 'XXX';
FLUSH PRIVILEGES;

[email protected]‘slt1ozd5lk9.novalocal’ 是对应账户，

XXX是我当前登录账号(root)的密码。

问题解决。
自己分析原因：
可能是因为使用[email protected]‘slt1ozd5lk9.novalocal 来启动的web服务。所以它也需要权限才能访问mysql。
都是对mysql不熟悉，才会有这样的问题。看来还需要深入地学习啊。

springboot jar项目部署linux出现linux用户没有权限的恶心问题

相关推荐