From: Warren Young
Date: January 7 2008 1:56pm
Subject: Re: mysql++ 3.0 beta2 Connecting troubles
List-Archive: http://lists.mysql.com/plusplus/7360
Message-Id: <47822F7C.7010302@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.