install issue

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 Answered by Tommy Tidehon in this comment.

I have now solved this;

The issue was that I had changed the sock adress in my.cnf and mysql had understood that.. The bug is that the mysql_secure_installation did not take any notice of the changes in my.cnf...

The easy solution to this was :to add a parameter.. i.e:

mysql_secure_installation --default-file=/etc/my.cnf

and then it works..

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.