Okay guys, slowly getting there... Inspired by
https://lists.launchpad.net/maria-developers/msg08315.html I figured out
that my plugin table in the mysql db was empty.
So
/etc/init.d/mysql stop
killall mysqld_safe
killall mysqld
mysqld_safe --skip-grant-tables &
INSERT INTO mysql.plugin (name, dl) VALUES ('unix_socket', 'auth_socket');
exit
/etc/init.d/mysql start
/etc/init.d/mysql stop
/etc/init.d/mysql start
did the trick for me, unix_socket is now enabled. Please don't ask why I
needed to start mysqld twice...
I guess that the installation of the plugin just did not work during the
upgrade. Could someone of the package maintainers cross-check this
(reference: https://lists.launchpad.net/maria-developers/msg08315.html)
After all, I still have the issue that after rebooting mysqld_safe and mysqld
are running. I think this is related to
https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1445549
user@system:~$ ps axu|grep -i mysql
root 1023 0.0 0.1 22572 3644 ? S 12:07 0:00 /bin/bash
/usr/bin/mysqld_safe
root 1024 0.0 0.1 24508 2560 ? S 12:07 0:00 logger -p
daemon.err -t /etc/init.d/mysql -i
mysql 1162 0.9 5.0 611932 102640 ? Sl 12:07 0:00
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql
--plugin-dir=/usr/lib/mysql/plugin --user=mysql
--log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock --port=3306
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447944
Title:
Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin
'unix_socket' is not loaded
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1447944/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs