phpMyFAQ

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?

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

Thorsten wrote: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.

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.

matteo wrote: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.

Hi,

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

bye
Thorsten