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 报错信息

Posted in 问题解决, 默认分类 | Tagged | Comments Off on MySQL数据库连接报错

MySQL导出表结构

Posted in 默认分类 | Tagged | Comments Off on MySQL导出表结构

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

Posted in 默认分类 | Tagged | Comments Off on MySQL密码重置