Problem connecting to mysql database via internet

[jay52]

Hi, I have an application that connects to a mysql database I have running on my local machine with the connection string "jdbc:mysql://localmachinename/dbname", it connects to the dbase when I am not connected to the internet but when I am connected to the internet it gives the message "Access denied for user '@%' to database". Could anyone give me a clue as to what I may have done wrong?
Secondly, I would like the database to be accessible to another user via the internet and I wonder if anyone has any guidelines on how I can do this. Thanks in advance.
Jay

 

[sleipnir214]

What is the relationship between the machine from which you are connecting to MySQL and the machine which is running the MySQL daemon?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[jay52]

Currently, its all on my local machine so when I need to connect to mysql, I start the server on my local machine, and connect to it, but I intend to leave the server running constantly for a few days so that it can receive connections from other machines.