- 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
- This is found under "Users and Privileges"
- 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
Page Comparison
General
Content
Integrations