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.
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.
