MariaDB / Mysql

2 posts / 0 new
Last post
#1 Tue, 04/16/2019 - 07:59
just_me Pro Licensee

MariaDB / Mysql

Well,

installed a new virtualmin server with Mariadb 10.1 with debian 9.8, but my application needs Mariadb 10.2. So i installed 10.2, and the mysql widget in webmin shows, that there is MySQL 10.2.3, but i cannot start it in Webmin MySQL module, but within the dashboard. Interestingly enough, some webpages show, others won't.

I also can't see the databases, although the webpages work, but virtualmin says: /usr/bin/mysqlshow: Plugin 'unix_socket' is not loaded

what can i do to fix it?

Thanks

Tue, 04/16/2019 - 08:19
just_me Pro Licensee

Well, i found something in www:

Open config file for editing:

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Add this to the [mysqld] section:

plugin-load-add = auth_socket.so

Save your changes and restart mariadb.

That's it.

Best j_m