javaee连接mysql数据库中出现的几个问题:
String driverStr = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/babys?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT";
我使用的是sql8版本,所以,driverStr应该改为com.mysql.cj.jdbc.Driver
url中本以为只写jdbc:mysql://localhost/babys即可,但是报错,网上一波搜索,找到这个url
另外tomcate中连接mysql需要在tomcate的lib文件夹下拷贝mysql-connector-java-5.1.7-bin.jar文件
如果运行中出现了Client does not support authentication protocol requested by server; consider upgrading MySQL client
这种问题,原因是mysql8 之前的版本中加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password(网上说的)所以在cmd中进入 mysql执行以下命令:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
FLUSH PRIVILEGES; #刷新权限