Hi, 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... Cheers, Ben Darlow ---------------------------Disclaimer--------------------------- Unless obviously public, this email is confidential to the intended recipient(s). If you received it in error please tell the sender and then delete it. We check emails from dyslexic.com and iansyst.co.uk, but you should virus check incoming emails. Emails do not always represent our official policy or a contract. Errors and omissions are excepted. iANSYST Ltd, Fen House, Fen Road, CAMBRIDGE, CB4 1UN. T +44(0)1223 420101; Fax +44(0) 1223 42 66 44; [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]