MySQL (workbench)

Owned by Selvyn Wright
Last updated: Jun 13, 2016
1 min read
  1. Install the workbench (google MySQL workbench for info)
  2. On the home screen you can open a script or create a new database or connect to a database
  4. Establish a connection to an existing DB or create a new DB
  5. 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
  6. Install the workbench on a remote client
  7. Using the same home screen connect to the remote server using its IP address and the user defined in 5 above
  8. Use this remote client to test the accessibility of the remote server before committing the login details to a java application