Re: *G* mysqld not listening on port 3306
On Tue, May 13, 2003 at 01:36:20PM -0000, 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:elacour@easter-eggs.com - http://www.easter-eggs.com
Reply to: