The Ultimate Guide to High Availability with MariaDB

install issue

You are viewing an old version of this question. View the current version here.

Trying to install mariaDB on OpenBSD andhave it working in openbsd:s default chroot:ed environment in /var/www and have thus changed the /etc/my.cnf sockets for [client] and [Mysqld] to /var/www/var/run/mysql/mysql.sock ( which will be in the chroot) have created the directory via mkdir -p /var/www/var/run/mysql chown _mysql:_mysql /var/www/var/run/mysql

Have then run the: pkg_add mariadb-server php-curl php-mysqli mysql_install_db rcctl start mysqld

all without problem but then when i try to run the

mysql_secure_installation

It says I can not connect to local myql server through socket /var/run/mysql/mysql.sock... (Error 2002 HY0000) and refuses to proceed. I am not surprised since i've change the path as obove in my.cnf --- but it seems not to pay any attention to that….

can you please advice me?

/Tommy

Answer

Hi Tommy,
I am not an OpenBSD specialist but can you please confirm first that you are able to connect to the mariadb server (are you sure it is running)?

Use for example:

 $ sudo mysql

Or

 $ ps fax | grep mysql

Regards,
Faustin

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.