Hi Elena, [root@one server ~]# rpm -qa | grep -iE 'mariadb|mysql' MariaDB-client-10.2.9-1.el7.centos.x86_64 MariaDB-compat-10.2.9-1.el7.centos.x86_64 MariaDB-common-10.2.9-1.el7.centos.x86_64 MariaDB-server-10.2.9-1.el7.centos.x86_64
[root@another server~]# rpm -qa | grep -iE 'mariadb|mysql' pcp-pmda-mysql-3.10.6-2.el7.x86_64 MariaDB-client-10.2.10-1.el7.centos.x86_64 MariaDB-server-10.2.10-1.el7.centos.x86_64 MariaDB-common-10.1.18-1.el7.centos.x86_64 Steps: I did the upgrade in two servers: In both servers (both 10.1), I follow the below steps and got ssame unix-socket not loaded error. set-up repo: curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash *yum update MariaDB-server MariaDB-client* MariaDB-Client installed successfully, but MariaDB-server thrown error that it couldn't update. then I remove the mariaDb-Server using below command: *yum remove MariaDB-server* then install: *yum install MariaDB-server* then mysql-upgrade: I got the error with unix-socket. Do you think yum update MariaDB-server caused this issue? Do I need to remove and then install, instead of update. Please advise. On Mon, Nov 13, 2017 at 4:49 PM, Elena Stepanova <ele...@montyprogram.com> wrote: > Hi Karthick, > > On 11/13/2017 11:11 AM, Karthick Subramanian wrote: > >> 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. >> > > This is strange, upgrade to packages *provided by MariaDB* shouldn't do > it. Packages provided by another party could be a different story. Could > you please paste the output of rpm -qa | grep -iE 'mariadb|mysql' or alike? > > >> 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 | >> --------------------------------------- >> > > The other way round is more common -- some variations of 10.1 did set > unix_socket authentication for local root and could have it enabled by > default, and then after upgrade to regular 10.2 unix_socket would become > disabled while root would still require it. > > Is it possible that your previous installation points at a different data > directory, while the old one that 10.2 now uses had this kind of > configuration before? > > Regards, > Elena > > > >> 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 >> >>
_______________________________________________ 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
