Re: [Refdb-users] could not connect to database server

[David K. <to...@xt...>]

Markus, I saw the mysql docs about the situation you describe, and at
the time I thought "This is big stuff, it can't possibly apply to a
little guy like me in a hurry" Thank you for the explanation and for
refdb, and your docs for sgml on NT too, which I use to understand what
is going on in my linux sgml installation!
David
 
Markus Hoenicka wrote:
> 
> Hi,
> 
> I think you both stumble over an oddity of the MySQL security
> system. If you allow access to a database from everywhere (%) this
> does not include access from localhost. You need a separate entry in
> the appropriate table to allow access from localhost. So e.g. if you
> manage your users through the (somewhat rudimentrary) refdba adduser
> command, you'd need two separate commands for each database, one using
> "%" (or a subnet or something) to allow remote access, and one using
> "localhost" to allow local access. And to be able to do this in the
> first place, your MySQL administrator account also needs two entries
> in the MySQL user table. You have to use the mysql client to do this
> manually.
> 
> This at least works with MySQL running on Debian stable. I specify
> 127.0.0.1 as the IP address of mysqld in my refdbd config file, so I
> don't have to use the name of the external net interface.
> 
> If this behaviour has changed in recent versions of MySQL, I'd finally
> have to upgrade and see what needs to be changed.