Sytze de Boer wrote: > Folk, please help me out > I'm trying to install Mysql and the odbc stuff > (I'm following Will Hentzen's book closely) > > I'm stuck on the ODBC installation, where I get the error Connection > failed [HY000][MySQL][ODBC 5.1 Driver] Can't connect to MySql server > on localhost (10061) > The book tells me this is a common error and that it may be firewall > related, but I don't have a firewall so I don't know what to do next. > > I've changed my network settings from automatic to 192.168.1.11 (etc) > When I ping localhost, it returns me 127.0.0.1 > I CAN ping 192.168.1.11 > > I suspect localhost should be 192.168.1.11 ????
First, try the telnet test: r...@sg25:~# telnet localhost 3306 Trying 127.0.0.1... Connected to paulmcnett.com. Escape character is '^]'. J 5.0.45-debian_1ubuntu3.3-l...@9<bWnC,b...@\3(jc1eConnection closed by foreign host. If you get a prompt like I did on port 3306, you are connecting to the MySQL server and something else is wrong with your odbc config. If instead it times out, which I suspect, your server isn't running where you expect. You probably need to edit your my.cnf file: 45 # Instead of skip-networking the default is now to listen only on 46 # localhost which is more compatible and is not less secure. 47 bind-address = 127.0.0.1 In my example, only 127.0.0.1 (localhost) can connect. If you want 192.168.1.11 to be the bind-address (so other machines can connect), change it appropriately. Another thing to check is the output of the netstat command. Look for listening ports, specifically 3306 for mysql. If it is listening, note which address it is listening on. If it doesn't appear, then the service is probably not started. Try "net start mysql" or go into Control Panel|Administrative Tools|Services and look for it, and start it. If it isn't listed, you didn't install it as a service and probably should reinstall with that option. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
