Hi Elena, Do you think the yum update causing issue instead of yum remove and yum install in the first place. Please advise.
On Nov 13, 2017 5:13 PM, "Karthick Subramanian" < ksubraman...@paycommerce.com> wrote: > 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
