Mysql, can't open port!

[EricD]

Allo!

I got a strange problem, or there is something that I don't get ...:confused:

I got a mysql server installed on a debian woody machine. Mysqld is running, I can ping the server but the mysql port isn't showing open when I scan my ports with nmap. ???

I get that error message when I try to connect to the database from a php script :

Call to undefined function: mysql_connect()

Obviously, it can't connect since the port isn't open.

php4 is compiled with mysql support. Everything seems to be fine but the port still closed!

Anybody ever saw that?

Thanx a lot for helping!

Ps: The databases, users and passwords are all well defined.

[Thanatos]

hmm...seen it...no firewall or router port forwarding/lack thereof/to the wrong machine issues? I use mysql, but I'm not very fluent. does it need to be config'ed to open up to the network specifically? have you looked at your .conf files?

[EricD]

Hi,

No, there seems to be nothing wrong with my.cnf or with my network.

It's my first try in setting up a Mysql server on Debian. I got one running on RH. I hear you think now...

“Why would you need another mysql server?”

Obviously, I don't need another one, but that problem just kept bugging me! :mad:

Now the easy question :

How do I use the RH mysql server from another machine on my lan? How do I point to that database?

I check on my side,

Thanx!

Eric,

[RobSmul]

The easy part:

Most pre-defined PHP-websites have an area where you have to put your data-base information. In most cases you need to define a server, database name and username and password.
Make the servername the name or the IP-address of the RH-machine.
You can post the code here and I'll look at it.


For the hard part:

I think it is a very odd problem. Have you tried to connect to the database in other ways? For instance using a MySQL administration program (I'm sure you can find one on download.com or freshmeat.org), or Webmin on your Linux-box itself?

Grtz rob