Remote MySQL access..

[Malignus Wingnut]

Hello all.

Curious as to whether or not it was possible to access my database:

1) Over a network
2) Over the internet


Reason I'm asking is cause I've already tried number 1, however even after forwarding the host port (3306) to my server computer, i am still unable to connect to it.

Note that I am using Kayot's Database Editor. It may be a compatability issue with that program, though I don't know. At any rate, some help would be nice.

Thanks for your time.

[John Adams]

Not sure if his tool requires MySQL ODBC 1.5 driver to be loaded, and configured as a DSN (I think GeorgeS' tools have this requirement). Check out MyODBC, and setup a system DSN pointing to your remote MySQL.

If you want access via internet, 3306 is the way to go (no firewall blocking it on any end, PC, router, or Server).

[Malignus Wingnut]

Is there some kind of configuration you have to do server-side with your MySQL server before remote connections are allowed?

Because all of my attempts, whether with MyODBC or with the database program itself, have failed.

[GeorgeS]

For my tools (perhaps Kayot's as well), you need to look at my help on my site. I have a description of how to do this using a linksys router and commands for MySQL.

This help is found further down on my main page site

GeorgeS

[sfisque]

Is there some kind of configuration you have to do server-side with your MySQL server before remote connections are allowed?

Because all of my attempts, whether with MyODBC or with the database program itself, have failed.

you have to define a user @ a remote host using this command:

http://dev.mysql.com/doc/refman/4.1/en/adding-users.html

lets say, you want to grant user eqemu access from the host "www.remotehost.com", you would use the GRANT command to allow that. otherwise, the dbms will only authorize localhost connections.

== sfisque