Hello to everyone.

I have a serious problem. I am currently hosted on a server in Greece that allows me only 2GB traffic. So I decided to move to another one. My problem is that I have a database that I update through mysql-front from windows. I also have a program that connects through ODBC to the database (mysql) and updates it. I have been trying to find a host that offers me the same functionality but I have been unable so far. The strange thing is that my current host (who is considered to be rather "small" and located in Greece) offers me this possibility.
If you please know any hosts that will provide me with such functionality please help me.
I am desparate.....:bawling:

What is the name of the programm which you are using? (windows-mysql thing)

mysqlfront. (there are several others that do the same thing, i.e. access mysql databases remotely).
Furthermore I have developed a program in Visual Basic which reads a text files and updates several tables in mysql database.
The question is here how do I administer my databases. I do not need web based software like phpMyAdmin. These are no good to me. I have a sports site which cannot be updated otherwise due to the special content.

I hope this helps.

Nek.

http://www.anse.de/mysqlfront/ = something like this?

EXACTLY LIKE THIS!!!!!

I think that you can use this tool with any web server that runs MySQL ( not sure about that API part ).

What you need I believe is a host that allows connections to mysql from remote locations, which most hosts will have disabled for security reasons. there are hosts that will make exceptions (e.g. if you give them the expected range of IP addresses that you will be logging in from they can allow access to your database from those IPs)

Probably the only way to find out if a particular host will allow something like this is to ask them. It is not something that is likely to be advertised in their FAQs.

Elsmore's points on IP ranges and remote connection security are very valid. To enhance this you may also want to see if a secure connection can be established to the mysql port using a security wrapper. That way all traffic between you and the server will be encypted.

Look for hosts offering either remote connection or access to the GRANT option for database admins. GRANT lets you create additional users and provide them access to all or parts of your database. We've provided this option for awhile and it's quite useful both for remote connections and enhancing script security on websites.

Sincerely,

-Matt