Connection ERROR to database in LAN !!

[ghazaliove]

Hi all,

In Cybercoffee, i puted a database folder in PC1, and
the application in PC2, i made the IP of the PC1 correctly,
When i trying to connect to database from one PC, i have
this error message.



What's the problem?!!
Thanks

[Thomas J.]

Is this problem during run and design time?
Are you able to connect to this IP using the MySQL tools http://dev.mysql.com/downloads/gui-tools/5.0.html

[ghazaliove]

This problem occured in RUN mode, i don't have Delphi
installed in Cyber.

Im using last MyDac vcl.
i'm not installing MySql server from MySql.com
because corelab told that no external files required !!

Hop to hear from you!

[eduardosic]

This problem occured in RUN mode, i don't have Delphi
installed in Cyber.

Im using last MyDac vcl.
i'm not installing MySql server from MySql.com
because corelab told that no external files required !!

Hop to hear from you!

Check if Port 3306 in Server Firewall is opened.

check in the server if the user have privilegies to connect from a remote machine.. Field Host in table mysql.user put % to allow connection for any IP.

[Thomas J.]

What is cybercoffe?

[ghazaliove]

Thanks for reply,
i don't understod, can you give me an example with source code?

[swierzbicki]

Hi ghazaliove,

If you want your software working over the LAN , you must install an SQL server. Given your example, install the MySQL server on the 192.168.0.2 workstation / server.

Be sure that the MySQL server is running on the workstation (look at the service manager and check that MySQL is running).
By default, MySQL is listening on the 3306 Port.
Check if Port 3306 in Server Firewall is opened.
You should also configure the MySQL.user table to add new users and allows them to connect on the server.

To configure your MySQL users use either the Corelab MyDac MySQL Tool manager or MySQL GUI Tools.

Bonne chance