- Joined
- Feb 27, 2003
- Messages
- 9,158
This is more of an FYI until we sort out a solution.
By default, we have MySQL setup the mysql.sock in:
The problem is that the fancy systemctl feature:
will create a hidden jail for the given process, so it's version of /tmp may differ from other services.
The current easy workaround is to edit:
and anything else that needs access to MySQL/MariaDB, and set:
Then reload the systectl daemon and restart all services
This is not my preference, but would at least all you to get past the issue for now.
A related error might look like
The fix we'll most likely use will be to move the .sock file to:
which would be /home/mysql/mysql.sock with the default symlinks.
John
By default, we have MySQL setup the mysql.sock in:
Code:
/tmp/mysql.sock
Code:
PrivateTmp=true
The current easy workaround is to edit:
Code:
/etc/systemd/system/mysqld.service
/etc/systemd/system/httpd.service
/etc/systemd/system/php-fpm*.service
/etc/systemd/system/directadmin.service
etc..
Code:
PrivateTmp=false
Code:
systemctl daemon-reload
This is not my preference, but would at least all you to get past the issue for now.
A related error might look like
Code:
Error: 2002 - No such file or directory
The fix we'll most likely use will be to move the .sock file to:
Code:
/usr/local/mysql/data/mysql.sock
John