Accessing PHP MySQl Application on client pC

[shiningworld_4u]

HI!

we have developed a supply chain system which offers administration and reporting as web application and for POS it uses a desktop application. we developed web application using Mysql and pHp, and for desktop application we have used C# 2008.

 

We have tested the application on our workstaion, by installing it on one workstation and installing the desktop application on other pc, by configuring the config file as follow, and allowing remote connection on mysql, we can access application from client pc.

 

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

  <appSettings>
    <add key="Connstring" value="SERVER=server;DATABASE=ac;UID=root;PASSWORD=supplychain;"/>
  </appSettings>


</configuration>

 

Our client has Server 2003 OS, and client have XP. Now we can access application on server, but when try to access it from client through desktop application it gives the following error.

 

Access Denied for user 'root'@'CL1' (using password = Yes)

 

where server name is "Server" and client name is "CL1".

 

Any help will be much appreciated.

 

Thanks in advance.

 

[Ruzzas]

Normally you need to allow your ip address to connect to the mysql server. Google it, I don't know how exactly to explain it...

[shiningworld_4u]

I have done so. During testing environment i have allowed IPs to access the Mysql and same is done on client's end.

[Mchl]

http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html

[shiningworld_4u]

http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html

 

The documentation provided on above link, helps me a lot to figure out the problem.

Issue is very simple, during allowing remote connection, in mysql.user table, query inserting wrong md5 code in password field.

 

just replace the password code with correct one and issue gone.

 

Thanks to all you guyz agian.