charels

字符集与校对集查看数据库默认字符集mysql> show variables like '%charact%';ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection id: 45169Current database: information

mysql mysqldump password insecure

现象：[root@test-1-dns1 ~]# mysql -utest -ptest -hxxx -P3309Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 140Server version: 5.7.12-log Source distributionTyp

1.修改参数配置文件vi /etc/my.cnf[mysqld]wait_timeout= 28800interactive_timeout=  28800#增加以上两列即可，因为官方文档要求修改此参数必须同时修改interactive_timeout  2.重启数据库Service mysql restart 3.查看数据库参数是否修改成功Show