Adding a user with rights to connect to moodle db using MySQL Workbench

For the third day in a row, my colleague was asking about the state of data in moodle.  Today, I added her to the users table in the mysql user table. Steps followed:

Adding a new user to the mysql table in the host DB instance

• Remoted into the moodle server (which is where the DB instance resides too)
• Used phpmyadmin to connect to the DB
• Browsed the mysql table
• Clicked on privileges
• Clicked on Add a new user
• Added the name and password
• Applied permissions to read, write, select , insert and delete records

Downloading, Installing MySQL Workbench and Connecting a user to the DB instance

• emailed my colleague and pointed her to a mysql workbench download that was on our network.
• instructed her to install mysql workbench
• walked over to her space and had her bring up the newly installed workbench
• had her click on New Connection in the SQL Development column
• specified the IP address to the server in the Hostname
• Specified Username just created
• Clicked on Password Store in Vault
• Specified password just created
• Clicked Test Connection - and - walla, first try it worked!
• Clicked OK to save the connection

I stayed a little longer to ensure the connection would actually open a window to the DB instance.  We saw all the moodle tables, clicked on a few, noticed some col. names and she was off and running.