Access the database without LOCALHOST

[MIG]

Is it possible to get access to my MySQL database thru an exe??

I made a prog in delphi7 want to access the MySQL database with ADO connection. with MySQL Provider v.3.

Now it's only possible to acces the database if i add my I.P. to the host of the database.

I want it to be accesible thru all ip's.

*** HELP *** 3 day's farther and no solution.

P.S. I tryed to add a wildchart to hosts like % and * but don't work.

 

[ballyn]

If you add "%" as the access host, this will allow anyone to connect to the database as the user you've specified.

If you log into phpmyadmin after you make this change, you should see it reflected in the "privileges" tab.

You can also use phpmyadmin to make this change (privileges -> add a new user).

Finally, you could also use the mysql client to make this change:

GRANT USAGE ON * . * TO 'username'@'%' IDENTIFIED BY 'password'
GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'%';