Accessing MySQL database

[Toppertje]

I wrote a program (.exe) that wants to access my MuSQL database online. This program will be distributed to customers.

I can't log in to the database with only a username and password. The only way i can get it to work is to add my ip address to the access host section.

Can anyone help me out, how I can make it work that other persons/clients can access my MySQL database.

Thanks for helping out!!!

[jerry2005]

If you open the mysql port TCP 3306 in your firewall , users can connect to the mysql server, if you want this is a other question.

[Toppertje]

Port 3306 is open.
Even with the firewall down it will not work.

[jerry2005]

What is the error message ? can you see anything in the log files ?

[Toppertje]

Want I want to do is the following.

I have a executable that looks in a mySQL database online.

In the DA mySQL mgmt onlu localhost has access.
I want to let all people with my program from different locations
direct connect to the mySQL database.

Now they have to first login to the domain to become localhost.

The error is the database caný be found or the username/password is incorrect.
When I add my IP to the Access Hosts logging in is no problem

[jmstacey]

I think you can use a wildcard (*) for for that if you want to allow connections from everybody.

[Toppertje]

ThX all for your help.

Everything working fine now