连接mysql数据库所遇到的问题

1.

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (CLIENT_PLUGIN_AUTH is required)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getLogWriter(BasicDataSource.java:1098)
    at org.apache.commons.dbcp.BasicDataSourceFactory.createDataSource(BasicDataSourceFactory.java:350)
    at com.yang.db.DB.<clinit>(DB.java:19)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:264)
    at com.intellij.rt.execution.application.AppMain.main(AppMain.java:123)

最开始我使用的mysql jar包为6.x版本，将其更改为5.x版本即可正常运行

2.

通过HeidiSQL连接MYSQL数据库报错：
 SQL Error (1130): Host 'sys' is not allowed to connect to this MySQL server
需更改 mysql 数据库里的 user表里的 host项把localhost改称%
首先按下面的步骤登录Mysql服务器

然后进行如下操作：
mysql>use mysql;

mysql>update user set host = '%'  where user ='root';
MariaDB [mysql]> update user set host = '%' where host = 'localhost';

mysql>flush privileges;
mysql> select host, user from user;
mysql>quit