Ubuntu
mysql-5.6 package

  1. Bug #1447944
  2. Comment #29

Comment 29 for bug 1447944

Revision history for this message
Markus (maier-m) wrote : Re: Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin 'unix_socket' is not loaded

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