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
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 mysqld_ safe /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
root 1023 0.0 0.1 22572 3644 ? S 12:07 0:00 /bin/bash /usr/bin/
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=