I have just finished setting up MySQL and PostgreSQL on my webserver, and both are running fine when I work from a shell on the server. For instance, I can connect to the MySQL from the shell, by typing
mysql

but if I try to connect through an IP address, i.e. by writing
mysql -h 127.0.0.1 --user root -p

I get the message
ERROR 2003: Can't conenct to MySQL server on '127.0.0.1" (111)

My firewall is properly configured to allow connections on 3306 so I doubt that that is the problem. In order to get the PostgreSQL server to accept connections, I had to add a crypitc line to the
/etc/rc.d/init.d/postgresql

file. Do I need to do something similar to get MySQL to accept connections?

I am using Fedora Core on an x86 machine

/Rukawa

See if it is listening with:
netstat -nlp

You may need a port option to be set - see:
http://www.mysql.com/doc/en/Option_files.html

Looks like it is listening:
unix 2 [ ACC ] STREAM LISTENING 17645 4461/mysqld /var/lib/mysql/mysql.sock

I tried adding the
port = 3306
to my.inf and the other suggestions from that site, but I still can't connect...

It should be /etc/my.cnf

Then restart mysql.

That line only shows a listening socket.

Thanks for the help it works now! I cleaned up the /etc/my.cnf file removing unnecessary info and added the port number as you explained. Restarted and now it works :-D

To other people: Note the [client] area where port and socket should be set, and note the list of skip-... statements that appear in the ini file. "skip-networking" must NOT appear if you want TCP/IP to work.

/Rukawa