where is the index physically located in MySQL database?

Can we connect a MYSQL db which is located in Win Server 2003 MS-IIS/6.0 from a Linux Apache server?

  • Please let me know whether is it possible to connect a MYSQL db which is located in Windows Server 2003 Microsoft-IIS/6.0 from a Linux Apache/1.3.37 (Unix) server. FYI, the mysql db connection file is in LINUX Apache server and the mysql database is in windows 2003 server. i have just replaced the necessary variables and tried to connect but it showed the below error. ======================================… <? mysql_connect("host name", "admin", "1admin") or die(mysql_error()); echo "Connected to MySQL "; mysql_select_db("test") or die(mysql_error()); echo "Connected to Database"; ?> ======================================… ======================================… Can't connect to MySQL server on 'host name' (4) ======================================…

  • Answer:

    make sure the mysql server is configured to allow connections from other computers, and that any firewals on windows (including the basic windows firewall) are set up to allow mysql to act as a server.

Mahesh at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Yes, i would suspect that your error is related to either a network connection or inability to resolve the name of the server.

JM

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.