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..
