List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:January 7 2008 1:56pm
Subject:Re: mysql++ 3.0 beta2 Connecting troubles
View as plain text  
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.
Thread
mysql++ 3.0 beta2 Connecting troublesBart Verstraete6 Jan
  • Re: mysql++ 3.0 beta2 Connecting troublesJonathan Wakely6 Jan
    • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete7 Jan
      • Re: mysql++ 3.0 beta2 Connecting troublesJim7 Jan
        • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete8 Jan
          • Re: mysql++ 3.0 beta2 Connecting troublesJim9 Jan
            • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
              • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
                • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
                  • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young11 Jan
  • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young7 Jan
    • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete8 Jan
      • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young8 Jan
        • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete8 Jan
          • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young8 Jan
            • Re: mysql++ 3.0 beta2 Connecting troublesBart Verstraete10 Jan
              • Re: mysql++ 3.0 beta2 Connecting troublesWarren Young11 Jan