There are several good options for using a graphical user interface (GUI) to connect to MySQL rather than the text-based command line. Whether you use a GUI or not is your preference, but it is important that you know they are available. These notes will show you how to set up MySQL Workbench for access to the londo MySQL database.
First, download MySQL Workbench.
Upon starting it the first time, you’ll need to create a new connection by clicking the + icon:
Type in the connection details exactly as shown, except change the username ‘jeckroth’ to your own username:
After clicking OK, you’ll have a connection (like a bookmark) that can be used whenever you open the Workbench. Double click the connection to connect.
Assuming the connection was set up properly, you will now see several panes. On the lower-left is a list of databses which, when expanded, will show tables in each database. In the middle you can type and execute SQL queries. On the right is a help display or “snippets” (saved bits of SQL code).
Expand a database in the lower-left pane and select a table. Right-click and choose to select the first 1000 rows. The middle pane will update to show the SQL query generated and executed, plus the results in a spreadsheet form.
A second option is phpMyAdmin, which works in your browser. Thus, you do not need to install any software.
Connect to phpMyAdmin using this address: https://londo.stetson.edu/phpmyadmin/. Log in with your MySQL credentials (not londo credentials).
Next, select your database and table from the tree on the left sidebar:
After selecting a table, you can execute SQL queries using the SQL menu link, then typing some SQL code and clicking Go. Modify your query with the “Edit inline” link below the input box.