Re: MySQL

[Keith Hodges <keith_hodges@yahoo.co.uk>]

Klaus Knopper wrote:
> Hi,
>
> On Sun, Jan 06, 2008 at 04:38:00PM +0000, Keith Hodges wrote:
>   
>> Hi,
>>
>> I have been attempting to run MySql such that it accepts remote connections.
>>
>> Having commented out bind-address in /etc/mysql/my.conf and after 10
>> hours of fiddling arround I am still no closer to achieving this. Indeed
>> it does not even accept a telnet from the local machine to an ip address
>>
>> e.g.
>> telnet 192.168.0.3 3306
>>
>> telnet 127.0.0.1 3306 does work as expected.
>>
>> Any help would be much appreciated.
>>     
>
> Not really Knoppix-related, but the key seems to be setting these
> options in /etc/mysql/my.conf:
>
>  - First comment-out all occurences of skip-networking, SkipNetworking or similar.
>
>  - Set bind-address       = 127.0.0.1
>                             ^^^^^^^^^replace by desired IP-Address(es)
>
> Then, restart mysqld and/or safe_mysqld or mysqld_safe.
> Additionally, you need to set the PERMISSIONS in the mysql database to
> allow connections from other places than "localhost".
>
> Regards
> -Klaus Knopper
>
>   
Thanks Klaus, but I have tried all of the above, and spent 10 hours
hanging out in #mysql  on irc.freenode.net
and non-of us were any the wiser.

Keith