[solved] Re: digikam 5.6 mariadb problem

[Simon Frei]

On 14/08/17 15:36, maderios wrote:
> On 08/14/2017 02:45 PM, Simon Frei wrote:
>> The problem is probably with the configuraiton of the mysql server:
>> If the option "bind-address" is set to anything else than
>> localhost/127.0.0.1 or 0.0.0.0 (any address) then you can only connact
>> with that specific address. If you didn't modify this yourself, maybe
>> you a mysql/mariadb update changed the default. Or I am wrong and this
>> isn't the problem after all :)
>>
> I found in /etc/mysql/mariadb.conf.d/50-server.cnf
> bind-address = 127.0.0.1
> I changed dk settings hostname 'localhost' --> '127.0.0.1'
> I can connect now :)
>
> Thanks Gilles & Simon
>
>
Glad the problem is solved.

I was puzzled that it makes a difference whether you use 'localhost' or
'127.0.0.1', I always assumed the former is just an alias for the
latter. A bit more googling brought up the following SO Q&A:
https://stackoverflow.com/questions/3715925/localhost-vs-127-0-0-1
The problem is that if you use 'localhost', mysql tries to connect via a
unix domain socket and ignores the port (which in your case was the
non-standard 3306). With '127.0.0.1' it connects via tcp/ip and uses the
given port.