在未指定配置文件的情况下,默认使用/etc/my.cnf文件
新增以下配置
【mysqld】
wait_timeout=1800
interactive_timeout=1800
两个属性同时设置才会生效。
执行 service mysql restart 命令重启mysql
进入mysql ,查看是否修改成功
输入该命令:
show variables like '%timeout%';
修改成功.
若修改配置后报错。
The server quit without updating PID file (/usr/local/mysql/data/host-5-5-5-165.pid).
可在配置文件中增加输出目录,并授权
datadir=/usr/local/mysql/data
[root@host-5-5-5-165 etc]# chmod -R 755 /usr/local/mysql/data
附配置文件
[mysqld]
user=root
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
port=3306
max_connections=200
max_connect_errors=10
character-set-server=utf8mb4
collation_server=utf8mb4_general_ci
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
lower_case_table_names=1
group_concat_max_len=102400
init_connect='SET NAMES utf8mb4'
datadir = /usr/local/mysql/data
wait_timeout=1800
interactive_timeout=1800
skip-character-set-client-handshake = true
socket=/tmp/mysql.sock
sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
[mysql]
default-character-set=utf8mb4
socket=/tmp/mysql.sock
[client]
socket=/tmp/mysql.sock
port=3306
default-character-set=utf8mb4