"Ben Darlow" <[EMAIL PROTECTED]> wrote: > > I've recently set up a new linux box and installed MySQL 4 (for the > record, Knoppix/Debian and the 'unstable' MySQL 4 package). I've had no > problems connecting using phpMyAdmin, but when I try to connect remotely > using MySQL Control Center or SQLyog (from Windows) I get the same error > (near enough) from both: > > SQLyog: > > --------------------------- > SQLyog > --------------------------- > Error No. 2003 > Can't connect to MySQL server on '[server]' (10061) > --------------------------- > > MySQL Control Center: > > [server] ERROR 2003: Can't connect to MySQL server on '[server]' > (10061) > > Searching through the mysql.com documentation led me to > http://www.mysql.com/doc/en/Can_not_connect_to_server.html, which talks > about unix and tcp/ip sockets. Running mysqladmin version gives me the > following output: > > mysqladmin Ver 8.40 Distrib 4.0.13, for pc-linux-gnu on i686 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult > AB > This software comes with ABSOLUTELY NO WARRANTY. This is free > software, > and you are welcome to modify and redistribute it under the GPL > license > > Server version 4.0.13-log > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /var/run/mysqld/mysqld.sock > Uptime: 2 hours 6 min 24 sec > > Threads: 3 Questions: 450 Slow queries: 0 Opens: 16 > Flush tables: 1 Open tables: 5 Queries per second avg: 0.059 > > Since the documentation (I forget where) showed the version output > showing the tcp port the server was running on (and mine doesn't), I am > led to believe the server isn't running on a tcp/ip socket. From what I > can tell though, my.cnf does have the necessary lines for doing this - > port=3306 (as per default) is in there, uncommented-out. > > Can anyone suggest what I might need to change in my configuration to > enable tcp/ip connections? All the search results I've seen so far > appear only to relate to people running MySQL (server) under windows... >
Did you run MySQL server with --skip-networking option? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
