Difference between revisions of "Connecting to the Database"
Altschuler (Talk | contribs) |
Altschuler (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | This guide will show you how to connect to a Poland Lab database using MySQL Workbench. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | This guide will show you how to connect | + | |
'''Step 1'''<br> | '''Step 1'''<br> | ||
| Line 12: | Line 8: | ||
'''Step 3'''<br> | '''Step 3'''<br> | ||
| − | Open the downloaded app and click on the plus sign next to "MySQL Connections." This will allow | + | Open the downloaded app and click on the plus sign next to "MySQL Connections." This will allow you to create and save your connection information for the database. |
Make sure the following information is in the fields: | Make sure the following information is in the fields: | ||
| Line 22: | Line 18: | ||
'''Step 4'''<br> | '''Step 4'''<br> | ||
| − | Once you are connected, click on the "Schemas" tab. You should see the database or list of databases that you have been given access to. Double-click the database name. Then double-click | + | Once you are connected, click on the "Schemas" tab. You should see the database or list of databases that you have been given access to. Double-click the database name. Then double-click "Tables." You should see a list of all the tables belonging to this database. You can now right-click on any table and select the "Select Rows" option. This will display the content of the table and also allow you to start querying the table using SQL. |
Revision as of 20:04, 11 February 2020
This guide will show you how to connect to a Poland Lab database using MySQL Workbench.
Step 1
Request a username/password from the Poland Lab.
Step 2
Go to https://dev.mysql.com/downloads/workbench/ to download MySQL Workbench.
Step 3
Open the downloaded app and click on the plus sign next to "MySQL Connections." This will allow you to create and save your connection information for the database.
Make sure the following information is in the fields:
- Connection Method: Standard (TCP/IP)
- Hostname: beocat.cis.ksu.edu
- Port: 6306
- Username: your-username
- Password: your-password
Step 4
Once you are connected, click on the "Schemas" tab. You should see the database or list of databases that you have been given access to. Double-click the database name. Then double-click "Tables." You should see a list of all the tables belonging to this database. You can now right-click on any table and select the "Select Rows" option. This will display the content of the table and also allow you to start querying the table using SQL.
