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

Reply via email to