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

小鱼儿 2022-03-26 18:24 480阅读 0赞

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;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE3MDExNDIz_size_16_color_FFFFFF_t_70]  
居然还真有这个。那么既然是权限问题，当然是授权了

GRANT ALL PRIVILEGES ON *.* TO root@'slt1ozd5lk9.novalocal' IDENTIFIED BY 'XXX';
    FLUSH PRIVILEGES;

root@‘slt1ozd5lk9.novalocal’ 是对应账户，

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

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

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE3MDExNDIz_size_16_color_FFFFFF_t_70]: /images/20220326/06797f91be8d4571b77b691d0fc2b8e2.png