Eclipse连接mySQL错误的解决方法
错误一:
报错:Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法:
1.打开mySQL输入use mysql;
2.输入(*号表示你自己的密码)alter user 'root'@'localhost' identified with mysql_native_password by '******';
3.输入(返回eclipse即可解决)flush privileges;
错误二:
报错:Unknown initial character set index ‘255’ received from server. Initial client character
解决方法:
在jdbc:mysql://127.0.0.1:3306/test后面加上 ?useUnicode=true&characterEncoding=utf8
即可解决
出现这个就说明连接成功了!!!
其他的小错误我觉得大家应该能解决(不能的欢迎评论,我帮你解决)
这里分享我的连接测试代码(首先要下载驱动包)没有的点击连接下载https://dev.mysql.com/downloads/connector/j/5.1.html
package com.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class connect {
// 数据库地址
private static String dbUrl = "jdbc:mysql://127.0.0.1:3306/book?useUnicode=true&characterEncoding=utf8";
// 用户名
private static String dbUserName = "root";
// 密码
private static String dbPassword = "123456";
// 驱动名称
private static String jdbcName = "com.mysql.cj.jdbc.Driver";
public static void main(String[] args) {
try {
Class.forName(jdbcName);
System.out.println("加载驱动成功!");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("加载驱动失败!");
}
Connection con = null;
try {
// 获取数据库连接
con = DriverManager.getConnection(dbUrl, dbUserName, dbPassword);
System.out.println("获取数据库连接成功!");
System.out.println("进行数据库操作!");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("获取数据库连接失败!");
} finally {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}