Warren Young schreef:
> Bart Verstraete wrote:
>> Why wont this work?
>> m_connected = connect("TEST", "127.0.0.1", "user", "pw", 3307);
>> It compiles without an error but while connecting it trows a
>> exception "Access denied ....blablabla". The db is tunneled via ssh
>> on port 3307
>> The following works if the db is installed localy.
>> m_connected = connect("TEST", 0, "user", "pw", 3306);
> MySQL's permissions system it's fairly complex, allowing fine-grained
> access control. One of the things it cares about is the host you're
> connecting *from*, which from the server's perspective is different
> with the tunnel. The MySQL debug log might have more information
> about what it didn't like.
In my permissions I set my user to any host. But no change.
> I also see that you're changing two variables here at the same time:
> the host name and the port. Change just one at a time to isolate the
> difference. There should be no functional difference between 0 and
> "127.0.0.1", so report it as a bug if there is, but until you try it
> with both port options, you don't know, you're guessing.
I tried all combis but if I use "127.0.0.1" as host, it can not connect
locally or via the tunnel, if I use 0 as host it connects locally but
not via the tunnel.