Mysql

To login to mysql from the shell as user root of mysql:

$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g.

If you don't yet have a mysql root user password:

mysql> SET PASSWORD FOR root@localhost=PASSWORD('SeCreT');

What databases exist: mysql> show databases;

To create a database: mysql> create database bsdcan; Query OK, 1 row affected (0.00 sec)

Create a user to with a grant of "all" where the username will be bsdadmin and the client machine is localhost: mysql> grant all on bsdcan.* to 'bsdadmin'@'localhost'; Query OK, 0 rows affected (0.09 sec)

Now let's use our new database: mysql> use bsdcan;

and see what tables exist: mysql> show tables;

Create a basic table: mysql> CREATE TABLE volunteers ( firstname VARCHAR(20),  lastname VARCHAR(20),  callsign VARCHAR(6),  shirtsize CHAR(2),  years CHAR(2),  location VARCHAR(20)  ); Query OK, 0 rows affected (0.01 sec)

Let's take a look at our new table: mysql> describe volunteers;

Now to load some data: mysql> INSERT INTO volunteers VALUES ('Diane','Bruce','va3db','l','2','room 412');

Edit the data, as ve3sql is now an extra large t-shirt: mysql> update volunteers set shirtsize='xl' where callsign='ve3sql';

what do we have in the table now? mysql> SELECT * FROM volunteers;

We accidently added a record with a volunteer we want to delete: mysql> delete from volunteers where callsign='ve3sql';