Re: [Refdb-users] could not connect to database server
Status: Beta
Brought to you by:
mhoenicka
|
From: David K. <to...@xt...> - 2002-03-07 09:21:40
|
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. |