Hello Friends,

Please let me know whether is it possible to connect a MYSQL db which is in Windows Server 2003 Microsoft-IIS/6.0 server from 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.


While trying to connect mysql db it is showing the below error.

=======================================
Can't connect to MySQL server on 'hostname' (4)
=======================================

Any idea ... Help me..

--
Thanks,
Mahesh

hi ... just login to your mysql server and Run this command:

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

USERNAME is the username that you would like to create.
IP is the public IP address of your remote connection.
PASSWORD is the password you would like to use for this username.

You now must flush MySQL's privileges. ....using the command command below:

FLUSH PRIVILEGES;

Run this command to exit MySQL:

exit;


check this to see if you are are able to connect to the server using telnet ...also check if you are not using any firewall at both end which needs to be configured.

[linux@ibm ~]$ telnet ipadderss 3306

It's never a good idea to give all privileges on all databases to a user. Privileges should only be granted on the databases you need access to and then only the minimum necessary to do your job.