2 Servers - Web server and MySQL Server

[ontherun]

We have 2 servers on an internal doman network

MySQL server 3rd-stone004 - 192.168.1.4
Web server 3rd-stone005 - 192.168.1.5

phpMyFAQ Setup

MySQL server: 192.168.1.4:3306
MySQL username: root
MySQL password: test
MySQL database: faq
Table prefix:

Error:

No connection to the MySQL server could be created. Please check your input for:

MySQL Server
MySQL username
MySQL password

Is there a way to make this connection happen on a local network?

[Thorsten]

Hi,

do you get a connection from the console from the webserver to the database server? Do you enabled the "skip-networking" option in the my.cnf MySQL configuration file?

bye
Thorsten

[ontherun]

Hi,

do you get a connection from the console from the webserver to the database server? Do you enabled the "skip-networking" option in the my.cnf MySQL configuration file?

bye
Thorsten

I have not been able to connect other than local.
and I have searched for the my.cnf file and did not locate
it in of the mySQL server file forders.

[matteo]

HI,
in what OS your MySQL server is installed? E.g. in Linux usually it is located in /etc/my.cnf while in Windows it is located in C:\my.cnf. Please check also the firewall configurations, if any, betwwen the two hosts: TCP 3306 traffic to the DB server must be enabled.

[ontherun]

HI,
in what OS your MySQL server is installed? E.g. in Linux usually it is located in /etc/my.cnf while in Windows it is located in C:\my.cnf. Please check also the firewall configurations, if any, betwwen the two hosts: TCP 3306 traffic to the DB server must be enabled.

Windows 2000 (both servers)
but the file is not in the root C:\ or C:\winnt
and yes I have porter 3306 for both systems

There is a file called my.ini in the c:\winnt folder
but no ref. to skip_network in it.

[Thorsten]

Hi,

on Windows the file should be in C:\Program Files\MySQL\MySQL Server 4.1\my.ini

bye
Thorsten