All,

Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to
login to root user as shown below:

mysql -u root

I got the error - unix_socket not loaded.

I noticed that the unix_socket authentication is required after the upgrade
for root login from localhost. Can anyone confirm whether this is part of
the feature after upgrades.

In my previous version:

select user, plugin from mysql.user;

+-----------+------+-------------+
| Host      | User | plugin      |
+-----------+------+-------------+
| localhost | root |                |
------------------------------------

After upgrade:

select user, plugin from mysql.user;

+-----------+------+-------------+
| Host      | User | plugin      |
+-----------+------+-------------+
| localhost | root | unix_socket |
---------------------------------------

Regards,
Karthick
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to