数据导入常见报错问题解决

报错一：plugin caching_sha2_password could not be loaded

解决办法：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
FLUSH PRIVILEGES;
 

报错二：mysql server has gone away

SET GLOBAL max_allowed_packet = 128 * 1024 * 1024 * 4;

报错三：java.sql.SQLRecoverableException

优化查询性能：select @@innodb_buffer_pool_size;
SET GLOBAL innodb_buffer_pool_size = 4294967296;