List:MySQL++« Previous MessageNext Message »
From:Bart Verstraete Date:January 8 2008 12:29pm
Subject:Re: mysql++ 3.0 beta2 Connecting troubles
View as plain text  

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