Difference between revisions of "Connecting to the Database"

From Poland Lab Wiki
Jump to: navigation, search
(Step 2)
Line 10: Line 10:
 
== Step 2 ==
 
== Step 2 ==
 
Open the downloaded app and click on the plus sign next to "MySQL Connections." This will allow us to create and save our connection information for the database.
 
Open the downloaded app and click on the plus sign next to "MySQL Connections." This will allow us to create and save our 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 3 ==
 
== Step 3 ==

Revision as of 19:51, 11 February 2020

There are two ways to connect to the database:

  1. Command line
  2. GUI software

This guide will show you how to connect in the second way (GUI software). There are many GUI software applications available. We will use MySQL Workbench.

Step 1

Go to https://dev.mysql.com/downloads/workbench/ to download MySQL Workbench.

Step 2

Open the downloaded app and click on the plus sign next to "MySQL Connections." This will allow us to create and save our 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 3