First steps with the MySQL command line utility

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 Cmd Line (mysql) icon on the desktop; there is a similar icon labelled MySQL Workbench which leads a GUI for managing a MySQL database server. You can also start the MySQL command line by typing

  "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe" -u{username} -p;

in a command or PowerShell window (where {username} is replaced with your MySQL login ID, in this case your JagNetID).

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.

The MySQL command line executes when you end a line with a semi-colon and press Enter.

show databases;

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);

show tables;