刚装了mysql8.0，用navicat登陆不了,会出现2059错误,只能用命令行登陆
1.找到配置文件my.ini
将default_authentication_plugin=caching_sha2_password改为default_authentication_plugin=mysql_native_password
2.用命令行登陆
mysql -u root -p
123456
3.use mysql
4.ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
5.flush privileges;
6.可以用navicat登陆了
报错如下：Cause: java.sql.SQLException: ORA-01653: unable to e...
刚装了mysql8.0，用navicat登陆不了,会出现2059错误,只能用命令行登陆 1.找到配置文件my.in...
Caused by: java.sql.SQLException: Connections could not b...
java.sql.SQLException: Query execution was interrupted, m...
java.sql.SQLException: java.lang.IllegalAccessError: clas...
java.sql.SQLException: connection holder is null Cause: j...
报错信息为： ### Cause: java.sql.SQLException: Parameter index ...
错误描述 java.sql.SQLException: The server time zone value '�...
Cause: java.sql.SQLException: Unknown initial character s...
报错内容： java.sql.SQLException: null, message from server: ...
本文标题：java.sql.SQLException: Unable to
本文链接：https://www.haomeiwen.com/subject/ochajftx.html
网友评论