Changed /var/lib/mysql/ to /home/mysql/

[michelrock89]

Hello Guys

I changed mysql folder to /home:

rsync -av /var/lib/mysql/ /home/mysql/

#/etc/my.cnf

datadir=/home/mysql
socket=/home/mysql/mysql.sock

#/etc/zabbix/zabbix_server.conf

DBSocket=/home/mysql/mysql.sock

#/etc/php.ini

mysql.default_socket = /home/mysql/mysql.sock

When accessing the frontend http://ip_zabbix/zabbix/ show up message below:

Database error

• Error connecting to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I had to move to /home because my / locale is full

Can anyone who has done this help ?

[Atsushi]

I don't know the information about the environment you are using, but if you are using a relatively new environment, try setting mysqli.default_socket instead of mysql.default_socket.

[michelrock89]

Hi Atsushi

Workf fine now

I Added in:

/etc/my.cnf

[client]
datadir=/home/mysql
socket=/home/mysql/mysql.sock

/etc/php.ini

[MySQLi]
mysqli.default_socket = /home/mysql/mysql.sock

Now, I'm using my zabbix database on /home with 1TB

Thank you so mutch my friend

See you.