fhljzcs的博客

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 在mysql my.ini中添加wait_timeout=86400即可

方法一： 打开cmd进入数据库 输入 set global time_zone = ‘+8:00’; set time_zone = ‘+8:00’; flush privileges; 方法二： 将serverTimezone 的Value属性修改为GMT 方法三： 在URL后添加serverTimezone=GMT%2B8

出现错误1166 Incorrect column name +‘字段名’。 就是这个是字段中有空格了，删掉即可。 当有多个错误时可通过Navicat SQL预览查看

mysql -uroot -ppassword #登录 use xxx; #选择数据库 ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #更改加密方式 ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; #更新用户密码 FLUSH PRIVILEGES; #刷新权限 ...