1.安装mysql8.0
1)配置文件my.ini(8.0的my.ini文件在D:\ProgramData\MySQL\MySQL Server 8.0文件夹中。
2.安装Navicat
1)连接到mysql出现 Client does not support authentication protocol requested by server;
解决办法:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
3.eclipse通过jdbc连接到 mysql
1)获取连接失败Could not create connection to database server.
所有安装都是最新版,故JDBC连接的jar包也需最新版
1)配置文件my.ini(8.0的my.ini文件在D:\ProgramData\MySQL\MySQL Server 8.0文件夹中。
2.安装Navicat
1)连接到mysql出现 Client does not support authentication protocol requested by server;
解决办法:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
3.eclipse通过jdbc连接到 mysql
1)获取连接失败Could not create connection to database server.
所有安装都是最新版,故JDBC连接的jar包也需最新版