*G* mysqld not listening on port 3306
i'm a beginner at mysql server - and i have the following problem i can connect to my database which is residing on my mail server from my web server. the my.cnf looks correct and has the port 3306 set , but can't telnet in eather . if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root it gives me the following error: Can't connect to MySQL server on x.x.x.x (111) many thanks greg
Re: *G* mysqld not listening on port 3306
On Tue, May 13, 2003 at 01:36:20PM -, Gregory Machin wrote: i'm a beginner at mysql server - and i have the following problem i can connect to my database which is residing on my mail server from my web server. the my.cnf looks correct and has the port 3306 set , but can't telnet in eather . if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root it gives me the following error: Can't connect to MySQL server on x.x.x.x (111) look at the skip-networking option in my.cnf and comment it. You also have to make sure mysql tables allow root to connect from your client host. Using documentation at mysql.com could be a great idea ;-) -- Emmanuel Lacour Easter-eggs 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 41 35 00 76 mailto:[EMAIL PROTECTED] -http://www.easter-eggs.com
Re: *G* mysqld not listening on port 3306
Gregory Machin wrote: i'm a beginner at mysql server - and i have the following problem i can connect to my database which is residing on my mail server from my web server. the my.cnf looks correct and has the port 3306 set , but can't telnet in eather . if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root it gives me the following error: Can't connect to MySQL server on x.x.x.x (111) many thanks greg The default debian configuration for mysql has the skip-networking option set in my.cnf. That is probably causing your problems. Simply comment that line in my.cnf and restart mysql. Maarten Vink
Re: *G* mysqld not listening on port 3306
Gregory Machin [EMAIL PROTECTED] wrote on Tue, 13 May 2003 13:36:20 - (UTC): i'm a beginner at mysql server - and i have the following problem i can connect to my database which is residing on my mail server from my web server. the my.cnf looks correct and has the port 3306 set , but can't telnet in eather . Did you remove/comment out 'skip-networking' in my.cnf? That should be the problem. Mit freundlichen Gruessen / Best regards Dominik Schulz
Re: *G* mysqld not listening on port 3306
On Tue, May 13, 2003 at 01:36:20PM -, Gregory Machin wrote: i'm a beginner at mysql server - and i have the following problem i can connect to my database which is residing on my mail server from my web server. the my.cnf looks correct and has the port 3306 set , but can't telnet in eather . You've to comment out the 'skip-networking'-entry in /etc/mysql/my.cnf. Bye, Jan.
Re: *G* mysqld not listening on port 3306
Op di 13-05-2003, om 15:36 schreef Gregory Machin: i'm a beginner at mysql server - and i have the following problem i can connect to my database which is residing on my mail server from my web server. the my.cnf looks correct and has the port 3306 set , but can't telnet in eather . if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root it gives me the following error: Can't connect to MySQL server on x.x.x.x (111) many thanks greg Did you enable your database server to accept connections from outside? The latest version doesn't open a TCP-socket! Kind regards! Diederik de Vries Heemraadsingel 188 3021 DM Rotterdam T: +31-10-4776515 F: +31-10-2440250
