Mac下Mysql8.0和5.5+配置区别总结
-
jdbc驱动名称区别
-
//旧版的jdbcDriver写法 String driver = "com.mysql.jdbc.Driver"; //新版的jdbcDriver写法 String driver = "com.mysql.cj.jdbc.Driver";
-
-
url参数变化
-
//mysql8.0后要将useSSL参数设为false,以及设置时区serverTimezone=UTC String url = "jdbc:mysql://localhost:3306/tms?useSSL=false&autoReconnect=true&serverTimezone=UTC&allowPublicKeyRetrieval=true";
-
-
忘记登录密码修改
-
苹果->系统偏好设置->最下面点MySql,关闭mysql服务
-
cd /usr/local/mysql/bin/ sudo su #输入(./mysqld_safe --skip-grant-tables &)回车以禁止mysql验证功能,mysql会自动重启 ./mysqld_safe --skip-grant-tables & ./mysql
-
#输入sql语句 flush privileges; #重置密码: #mysql5.5+版本 ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码'; #mysql8.0版本 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; #重启mysql sudo /usr/local/mysql/support-files(这个文件夹名称以安装的mysql为准)/mysql.server restart
-
-
mysql-connector-java版本区别
- 该版本号要与mysql版本号一致
- 下载网址:https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.24