Move soket MariaDB for zabbix

[GeorgeKup]

The / data section was created to which the database files from / var / lib / mysql were moved.

The path for the MariaDB socket, /data/mysql/mysql.socket, was specified in the my.cnf file. In addition, the path to the new socket was specified in the zabbix.conf configuration file.

The socket is created in a new location on the / data section and the database is started, only installing zabbix does not see the socket in the new location.

Now the database is on the / data section, and the socket file on the other section is /var/lib.mysql. Do not tell me how bad it is that the socket file and the database are on the same server, but in different sections?

[tim.mooney]

You haven't caused any long-term problems, you just need to fix where the socket is created on startup.

You need to make sure that the 'socket' setting is present in both the

[mysqld]
socket = /data/mysql.sock

and in the

[client]
socket = /data/mysql.sock

sections of your my.cnf. If it's only specified in the [client] section, that's not enough.

If you're using an older version of MariaDB, you may also want to specify the socket setting in the [mysqld_safe] section.

Once you've done that, restart. The MariaDB server should create the local connection socket in the correct place.