——————-Apr 27, 2015 @ 10:45——————-

NOTICE!!!!

https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1447944/comments/9

said this will cause a problem, which may enables everyone login with root with no password.

However, as I tried, access is denied when login without password.

So this should not be a problem.

After using the script, please try mysql -uroot, and if you can login into mysql with no password, restart mysql by /etc/init.d/mysql stop && /etc/init.d/mysql start. Try mysql -uroot again, if you can still login as root with no password, then you should undo the things by login into the mysql and update user set plugin=’unix-socket’ where User=’root’;flush privileges; exit then /etc/init.d/mysql stop && /etc/init.d/mysql start

 

or you can also change the same part of the script to do the same thing.

If there is really something wrong with the script (such as but not limited to causing security problems or unstable, etc.), please leave a comment under here.

——————-Apr 26, 2015 @ 21:22——————-

After upgrade to Ubuntu 15.04, MariaDB always saids “MariaDB Plugin ‘unix_socket’ is not loaded”

I suffered from this problem for hours, and finally I solved it.

From http://ubuntuforums.org/showthread.php?t=2275033

Thanks for sergerod  & nerdtron
I had fixed my problem.
What I did is to combine their commands.
Do nerdron’s answer first.

 

Here is a script, and I think it is useful.

http://c.zxq.io/savemariadb.sh

I tested the script, so it should work.

If the script doesn’t work, then do the things below manually.

And, if the script is not functional, please report to me by commenting.

 

Here’s what I did and saved my MariaDB.
Stop mysql:
1. /etc/init.d/mysql stop and killall -9 mysqld

Make sure no mysqld is exist.

Run mysql with skip grants to be able to login without any password
2. mysqld_safe –skip-grant-tables &

Login as root
3. mysql -u root

then is sergerod’s.

[mysql] use mysql;
[mysql] update user set plugin=” where User=’root’;
[mysql] flush privileges;
[mysql] \q or exit

and then:

/etc/init.d/mysql stop (or service mysql stop) and killall -9 mysqld (Using killall -9 will have a better effect, as @dwi said in the commenting area.)
and start the mysql thru
service mysql start or /etc/init.d/mysql restart

and it’s all done!