这篇文章主要介绍了Mysql数据库从5.6.28版本升到8.0.11版本过程中遇到的问题及解决方法,解决办法有三种,每种方法给大家介绍的都很详细
mysql数据库版本从5.6.28升到8.0.11过程中部署项目时遇到的问题和解决方法,具体介绍如下所示:
mysql5.6.28没换到8.0.11,启动报错
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
### The error may exist in cn\test\dao\StudentDao.xml
### The error may involve cn.test.dao.StudentDao.selectMultiParam
### The error occurred while executing a query
### Cause: java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
修改后仍有错误,再进行下面的操作
- 1
重新装mysql8,注意选择第二种,保留旧的加密方式。 - 2
MySQL Installer可以直接修改Authentication Method配置
- 3
直接执行语句修改
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.11 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
注:root是用户名,localhost是特指本机,mysql_native_password是旧的密码验证机制,123456是密码
然后就能正常运行了。