Hi, Check your /etc/hosts file for localhost definition. I would guess it is not only 127.0.0.1. I think you have IPv6 ::1 address too.
If so, try connect using 172.0.0.1 and add a GRANT with the same password for 'slurm'@'::1'; That will allow connections using IPv4 and IPv6 loopback address. Cordialement / Best regards, Sébastien VIGNERON CRIANN, Ingénieur / Engineer Technopôle du Madrillet 745, avenue de l'Université 76800 Saint-Etienne du Rouvray - France tél.☎️ +33 2 32 91 42 91 fax. +33 2 32 91 42 92 http://www.criann.fr mailto:sebastien.vigne...@criann.fr support: supp...@criann.fr > Le 5 mars 2025 à 03:04, Steven Jones via slurm-users > <slurm-users@lists.schedmd.com> a écrit : > > I had already tried that but here it is, looks OK to me. > > ====== > [root@vuwunicoslurmd3 slurm]# mysql -h 127.0.0.1 -u slurm -p > Enter password: > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 12583 > Server version: 10.11.10-MariaDB MariaDB Server > > Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. > > MariaDB [(none)]> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | slurm_acct_db | > +--------------------+ > 2 rows in set (0.000 sec) > > MariaDB [(none)]> > ======== > > regards > Steven > From: Christopher Samuel via slurm-users <slurm-users@lists.schedmd.com> > Sent: Wednesday, 5 March 2025 2:51 pm > To: slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com> > Subject: [slurm-users] Re: mariadb refusing access > On 3/4/25 5:23 pm, Steven Jones via slurm-users wrote: > > > However mysql -u slurm -p works just fine so it seems to be a config > > error for slurmdbd > > Try: > > mysql -h 127.0.0.1 -u slurm -p > > IIRC without that it'll try a UNIX domain socket and not try and connect > via TCP/IP. > > -- > Chris Samuel : > https://apc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.csamuel.org%2F&data=05%7C02%7Csteven.jones%40vuw.ac.nz%7C9e6208744a254ba3d31008dd5b898069%7Ccfe63e236951427e8683bb84dcf1d20c%7C0%7C0%7C638767368335219563%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=zi7ay%2B%2FO85t1MKA%2BB6e463Nku1aa0auoTkkdRHLBNJo%3D&reserved=0 > : Berkeley, CA, USA > > -- > slurm-users mailing list -- slurm-users@lists.schedmd.com > To unsubscribe send an email to slurm-users-le...@lists.schedmd.com > > -- > slurm-users mailing list -- slurm-users@lists.schedmd.com > To unsubscribe send an email to slurm-users-le...@lists.schedmd.com -- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-le...@lists.schedmd.com
