• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Can't modify my.cnf file

J

juanchi

Guest
This is my actual my.cnf file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Then I tried to include this three lines:

set-variable = interactive_timeout = 120
set-variable = wait_timeout = 120
set-variable = max_connections = 200

Like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = interactive_timeout = 120
set-variable = wait_timeout = 120
set-variable = max_connections = 200


[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

But when I restart mysqld service the conection to the database is broken, I can't log to the plesk control panel.

This is part of my mysqld.log file:

050327 22:07:27 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'

050327 22:07:27 mysqld ended

050327 22:07:29 mysqld started
050327 22:07:29 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'

050327 22:07:29 mysqld ended

050327 22:08:11 mysqld started
050327 22:08:11 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'

050327 22:08:11 mysqld ended

050327 22:09:03 mysqld started
050327 22:09:04 InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
050327 22:09:06 /usr/libexec/mysqld: Normal shutdown

050327 22:09:06 InnoDB: Starting shutdown...
A mysqld process already exists at Sun Mar 27 22:09:06 EST 2005
050327 22:09:08 InnoDB: Shutdown completed
050327 22:09:08 /usr/libexec/mysqld: Shutdown Complete

050327 22:09:08 mysqld ended

050327 22:10:54 mysqld started
050327 22:10:54 InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
050327 22:10:56 /usr/libexec/mysqld: Normal shutdown

050327 22:10:56 InnoDB: Starting shutdown...
A mysqld process already exists at Sun Mar 27 22:10:56 EST 2005
050327 22:10:58 InnoDB: Shutdown completed
050327 22:10:58 /usr/libexec/mysqld: Shutdown Complete

050327 22:10:58 mysqld ended

050327 22:12:11 mysqld started

If I reverse this changes everything works fine again, I don't know what I'm doing wrong, I used both pico and nano.
 
Back
Top