---

Accessing the MySQL server

---

• A graphical mySQL client
  • I have a graphical MySQL client application that you can use to access the MySQL server (which is loaded with a few databases)

    The client is called cs554-sql and it is stored in the directory /home/cs554001/bin

    ---

    ---

  • To run the cs554-sql client:

    Method 1: direct command line Execute this command from a terminal window: /home/cs554001/bin/cs554-sql Method 2: set your PATH variable Do this once: 1. Edit your startup file (for bash: .bashrc) 2. Add this path to your PATH variable: export PATH=$PATH:/home/cs554001/bin 3. Source the startup file (or logout and log back in) You can now run the client with this command: cs554-sql

  ---

  ---

  ---

  ---

• The avaibale databases
  • I have loaded the following databases into the MySQL server:

    companyDB: this is the database used to teach SQL spjDB: this is the database used in the homework assignment