Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  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
  3. Establish a connection to an existing DB or create a new DB
  4. 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
  5. Install the workbench on a remote client
  6. Using the same home screen connect to the remote server using its IP address and the user defined in 5 above
  7. Use this remote client to test the accessibility of the remote server before committing the login details to a java application