After a cursory reading, it looks OK. But don't forget to read the
supplied documentation, after installing the package:
less /usr/local/share/doc/pkg-readmes/mariadb-server
Also, most of those steps don't have to do with mariadb, but with simple
system administration. Installing the package, starting and stopping
services, and checking if processes are running and ports are open are
all tasks you should be familiar with.
All good to this point, thanks.
Now I'm reading this in
/usr/local/share/doc/pkg-readmes/mariadb-server
Given that lighttpd runs in chroot am I correct that I need to run the
following
install and then edit /etc/my.cnf for things to play nicely together?
Thanks,
David
--------------------------------------------------------------------------------------------------------------------
chrooted daemons and MariaDB socket
===================================
For external program running under a chroot(8) to be able to access the
MariaDB server without using a network connection, the socket must be
placed inside the chroot.
e.g. httpd(8) or nginx(8): connecting to MariaDB from PHP
---------------------------------------------------------
Create a directory for the MariaDB socket:
# install -d -m 0711 -o _mysql -g _mysql /var/www/var/run/mysql
Adjust /etc/my.cnf to use the socket in the chroot - this
applies to both client and server processes:
[client-server]
socket = /var/www/var/run/mysql/mysql.sock
