I want to allow some users on my Linux 9.0 web server to access a MySQL database on my server via the internet. They must be able to create and update tables in the MySQL database. Does anyone know of a MySQL client application that can connect to a MySQL database on a Linux web server across the internet? Also, what configurations would be necessary for this to be done? Thanks KBB

Not sure if this is what you are after, but you can achieve that with either perl, php or some other scripting language and a little knowledge of SQL queries and HTML.

You can use ODBC to access MySQL from a number of applications such as MS Access, MS Excel...you just need those users a.) to install the MyODBC driver for their system (Windows, Mac, Linux) and b.) make sure their user account has a host entry of % or a static IP address they are coming from. If these are coming accross the Internet, mind you that they are unencrypted. You may look into something like 'stunnel' to encrypt the communication depending on how sensitive the data is. You can find a number of 'mysql gui client' on google. I haven't used many, but there seem to be a handful to choose from... DrS