MySQL (workbench)

Install the workbench (google MySQL workbench for info)
On the home screen you can open a script or create a new database or connect to a database
Establish a connection to an existing DB or create a new DB
Create a user other than root, you will need this for remote connections
1. This is found under "Users and Privileges"
2. Set the field "Limit to Hosts Matching" to % (this is the wildcard meaning anyone host can attach to it
Install the workbench on a remote client
Using the same home screen connect to the remote server using its IP address and the user defined in 5 above
Use this remote client to test the accessibility of the remote server before committing the login details to a java application

MAN - Software Development