Tag Archives: MySQL
MySQL数据库连接报错
解决方法 在数据库连接后面加 ?useUnicode=true&useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useAffectedRows=true&allowMultiQueries=true 如果是xml文件，加 ?useUnicode=true&useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useAffectedRows=true&allowMultiQueries=true 报错信息
MySQL密码重置
修改 MySQL 配置文件以跳过密码登录 # vim /etc/my.cnf 添加skip-grant-tables; 重启 MySQL 服务 # systemctl restart mysqld.service 登录修改 [root@cvm-3ibcdh728a225 html]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.7.34 MySQL Community … Continue reading