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-leave@lists.schedmd.com