First steps with the MySQL Workbench

Log into the remote desktop vm-1.techcats.solutions

My login for this demo is tstudent but substitute your JagNetID (AU email before the @ sign) for tstudent

Double-click the MySQL Workbench icon on the desktop; there is a similar icon labelled MySQL Cmd Line which leads a command line interface for managing a MySQL database server; if you accidentaly get into MySQL command line, just type quit, press Enter and press Enter again.

MySQL can ostensibly be configured to use Windows authentication but I couldn't get this to work, so you login with your JagNetID and a password the same as your claim code for your TechCats VM subscription.

Note that MySQL with its current security settings lets you only create, see and work with databases that begin with your JagNetID so prefix your database names with your JagNetID. Trying a different type of name will result in an error. Also, names must be all lower case.

My demo will create a database tstudentdemo and then create the share table from Watson Chapter 3

CREATE TABLE share (
  shrcode CHAR(3),
  shrfirm VARCHAR(20) NOT NULL,
  shrprice DECIMAL(6,2),
  shrqty DECIMAL(8),
  shrdiv DECIMAL(5,2),
  shrpe DECIMAL(2),
  PRIMARY KEY (shrcode));

INSERT INTO share
  (shrcode,shrfirm,shrprice,shrqty,shrdiv,shrpe)
  VALUES ('FC','Freedonia Copper',27.5,10529,1.84,16);