idea搭建springboot+mybatis 查询数据库报错.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is require

1.报错信息
Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.

Wed Apr 03 11:23:12 CST 2019
There was an unexpected error (type=Internal Server Error, status=500).
nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required ### The error may exist in file [D:\workspace-zhoug\springboot\springboot-start\demo\target\classes\mapper\userMapper.xml] ### The error may involve com.zg.demo.mapper.userMapper.selectAll ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

2.
原因：由于刚开始没有指定mysql的版本，所以一直报错，指定版本后可以查询