( bodnarj | 2022. 05. 17., k – 07:40 )

A fejlesztőin.

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
skip-grant-tables
#innodb_force_recovery = 4

default-time-zone='+00:00'

A VPS-en:

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
skip-grant-tables

Itt van egy mysqldump.cnf állomány is:

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

+ egy mysqld.conf is ami nincs a fejlesztőin (vagy csak én nem találom)

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
key_buffer_size         = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
myisam-recover-options  = BACKUP
query_cache_limit       = 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days        = 10
max_binlog_size   = 100M

 

5.7.38-as verzió a fejlesztőin 5.7.26 a VPS-en.