学习中关于MySQL遇到的一些问题

net start mysql提示：服务名无效
1.win+R打开运行窗口，输入services.msc
2.在其中查看mysql的服务名
3.以管理员身份打开cmd，输入net start MySQL57

加载类“com.mysql.jdbc.Driver” 。在新的版本中已被弃用。新的驱动程序类是`com.mysql.cj.jdbc.Driver’

?useSSL=false&serverTimezone=GMT%2B8&useSSL=false
WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
解决方法：在原来的数据库名称后面添加：?useSSL=false
例如：URL =“jdbc:mysql://localhost:3306/sm?useSSL=false”

The server time zone value ‘???ú±ê×??±??’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
解决方法：
在原来的数据库名称后面添加：&serverTimezone=GMT%2B8&useSSL=false
例如：
URL=“jdbc:mysql://localhost:3306/sm?useSSL=false&serverTimezone=GMT%2B8&useSSL=false”

mybatis向mysql数据库中插入数据报错Field ‘id’ doesn’t have a default value: 将mysql中对应表的id字段设置为自增即可

hibernate配置cfg.xml 连接MySQL8时可能会出现
The reference to entity “serverTimezone” must end with the ‘;’ delimiter.错误
出现这个错误就是由于mysql8.0的连接驱动是jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC中间有个& 故报错
转义成&即可解决
在.xml文件中有五种字符必须转义才能使用
分别是
> == > 大于号
< == < 小于号
& == & 和
’ == ’ 单引号
" == " 双引号