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