nick@Vaxis:~$ ssh nick@artemis.cs.csub.edu
nick@artemis.cs.csub.edu's password:
Linux artemis 5.10.0-28-amd64 #1 SMP Debian 5.10.209-2 (2024-01-31) x86_64

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Wed Oct  2 12:16:51 2024 from 136.168.38.34
nick@artemis:~$ pwd
/home/fac/nick
nick@artemis:~$ users
akoli bbarrios cmorenoyanes dbaird djimenezgarc eroblestena iperez ipitts jcornejo jsweeny nick pluhar smonungolh steve
nick@artemis:~$ users | wc
      1      15     127
nick@artemis:~$ mysql -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BWelcome to the MariaDB monitor.  Commands end with ; or \g.
BBYour MariaDB connection id is 45823
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10

BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

BMariaDB [nick]> exit
BBye
Bnick@artemis:~$ mysql -p nick
Enter password:
ERROR 1045 (28000): Access denied for user 'nick'@'localhost' (using password: YES)
BBnick@artemis:~$ mysql -p nick
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BWelcome to the MariaDB monitor.  Commands end with ; or \g.
BBYour MariaDB connection id is 45847
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10

BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

BMariaDB [nick]> show databases;
+---------------------+
| Database	      |
+---------------------+
| 3420_lab7_tmp       |
| 3420_sql_lab	      |
| 3420_timeslots      |
| 4420s23	      |
| aalmaitah	      |
| aalmanza	      |
| aamistoso	      |
| aarcosavalos	      |
| aattiaibrahi	      |
| abotello	      |
| acardenassil	      |
| acazares	      |
| aceballos	      |
| adiazperez	      |
| aesa		      |
| agonzalezcej	      |
| ailarde	      |
| akoli 	      |
| alittle	      |
| alternativee	      |
| amanz 	      |
| amartinez	      |
| amilin	      |
| amunoz	      |
| anguyen	      |
| anicholas	      |
| aortega	      |
| apacheco	      |
| aparriott	      |
| apea		      |
| aportillo	      |
| arivera	      |
| arodriguez	      |
| aserrano	      |
| atmmanager	      |
| atorres	      |
| autosource	      |
| avu		      |
| aynostroza	      |
| azacariasvil	      |
| azurita	      |
| baseballlineup      |
| baung 	      |
| bayapantecat	      |
| bbarrios	      |
| bbowers	      |
| benco 	      |
| bestrada	      |
| bibliotech	      |
| bjones	      |
| blockbuster2	      |
| bobabuddy	      |
| booksbooksbooks     |
| bookworm	      |
| bparsons	      |
| brodriguez	      |
| bruiz 	      |
| bsmelser	      |
| bstitt	      |
| btate 	      |
| buddydj	      |
| candersen	      |
| cart_pushers	      |
| cestes	      |
| cgallegos	      |
| chatroom	      |
| chernandez	      |
| cmartinez	      |
| cmorenoyanes	      |
| cnavarro	      |
| cokpara	      |
| company	      |
| companyf23	      |
| companyf24	      |
| companys23	      |
| companys24	      |
| csandoval	      |
| cschmiedel	      |
| ctansen	      |
| ctennison	      |
| cviramontes	      |
| danzaldo	      |
| databaes	      |
| databoyz	      |
| dbaird	      |
| dbalderas	      |
| dbenavides	      |
| dcasas	      |
| dcerrato	      |
| deejayscafe	      |
| dfanucchi	      |
| dflores	      |
| dgonzalez	      |
| dgonzalez2	      |
| dgutierrez	      |
| division	      |
| djimenezgarc	      |
| djosep	      |
| dlopez	      |
| dmacias	      |
| dmesa 	      |
| dontpanic	      |
| dpham 	      |
| dreamsync	      |
| drivera	      |
| dsimpson	      |
| dware 	      |
| dwelch	      |
| earroyo	      |
| ecastaneda	      |
| eescutiaeche	      |
| efelicidario	      |
| egamino	      |
| ehsan_demo	      |
| ekyles	      |
| eldenbees	      |
| emckenna	      |
| employees	      |
| eosornio	      |
| eposting	      |
| eramossorian	      |
| eroblestena	      |
| erosales	      |
| esnopko	      |
| etagaca	      |
| etapiaramire	      |
| eturallo	      |
| ewarren	      |
| fantasyteambuilder  |
| financingfordummies |
| flightclub	      |
| flin		      |
| fmateolazo	      |
| furniture_store     |
| furryfriendfinder   |
| gamesdb	      |
| gcaragchiu	      |
| ggregory	      |
| gistory	      |
| gititfresh	      |
| gjimenez	      |
| gjimenez2	      |
| gjimenezroja	      |
| grading_lab6	      |
| grading_sql_lab     |
| group3part2	      |
| gtorres	      |
| guilddb	      |
| gymjam	      |
| gymtraffic	      |
| gzepeda	      |
| hallen	      |
| hardwaremerchants   |
| hayleeco	      |
| hbal		      |
| hcheema	      |
| hellodb	      |
| hjonasdottir	      |
| hmartinez	      |
| hmmc		      |
| honestcollective    |
| hotelbookingsystem  |
| hpascual	      |
| hrocha	      |
| hzhang	      |
| ichavez	      |
| imacias	      |
| imalleaux	      |
| inerizavala	      |
| inform_a_fish       |
| information_schema  |
| ingredients_proj    |
| iperez	      |
| ipitts	      |
| iruiz 	      |
| isamara	      |
| jacosta	      |
| jalejo	      |
| jambriz	      |
| jarenas	      |
| jarf		      |
| jarzate	      |
| jbaltazarrob	      |
| jbankston	      |
| jbuechel	      |
| jcanales	      |
| jchicas	      |
| jcornejo	      |
| jcox		      |
| jflanders	      |
| jflores	      |
| jgarcia	      |
| jguarcasgarc	      |
| jhernandez	      |
| jhicks	      |
| jjellie	      |
| jkuo		      |
| jmiranda	      |
| jmorley	      |
| jnukpese	      |
| jparks	      |
| jpereyra	      |
| jpocasangre	      |
| jpompa	      |
| jquinonez	      |
| jramirez	      |
| jramos	      |
| jrivera	      |
| jrocha	      |
| jrodriguez	      |
| jrojas	      |
| jsierradiaz	      |
| jsoto 	      |
| jsweeny	      |
| jtagaca	      |
| julloa	      |
| jzamora	      |
| kanaya	      |
| kcarrillo	      |
| kcoggshall	      |
| klappin	      |
| kmedrano	      |
| ksantiago	      |
| lab6		      |
| laguilar	      |
| lc_test	      |
| ldiaz 	      |
| learnapp	      |
| lgamboa	      |
| lgomez	      |
| librarymanpreet     |
| lmoreno	      |
| lost+found	      |
| lost_items	      |
| lostchapter	      |
| lrojo 	      |
| luxuryautomotives   |
| mabadi	      |
| macosta	      |
| mail_verify	      |
| malevolentkitchen   |
| mangeles	      |
| mbuenonunez	      |
| mcha		      |
| mdeguia	      |
| mealdb	      |
| melvir	      |
| mervin	      |
| mestrada	      |
| metchison	      |
| mfuentesrive	      |
| mgarris	      |
| mgutierrez	      |
| mjimenez	      |
| mkausch	      |
| mlara 	      |
| mlara2	      |
| montiveros	      |
| movie_test	      |
| moviedb	      |
| mraya 	      |
| msaini	      |
| mschmidt	      |
| msteiner	      |
| mtaylor	      |
| mvargas	      |
| mwehrmeyer	      |
| mwisehart	      |
| myhealthypet	      |
| mysql 	      |
| nanocenter	      |
| nanocenter2	      |
| nanocenterv2	      |
| nchiang	      |
| nclark	      |
| nflanders	      |
| nflessati	      |
| niche 	      |
| nick		      |
| nleyvarodrig	      |
| nmalleaux	      |
| nnguyen	      |
| npitts	      |
| nromasanta	      |
| ntoothman	      |
| nwardinsky	      |
| ocastillo	      |
| onlineordertracker  |
| orohina	      |
| paypool	      |
| pcruz 	      |
| performance_schema  |
| plantpage	      |
| pluhar	      |
| pokemonteambuilder  |
| ppark 	      |
| procrastiplanner    |
| prodriguez	      |
| prodriguezqu	      |
| projectfood	      |
| ptakkar	      |
| pzavala	      |
| quizdemo	      |
| ramrod	      |
| rateem	      |
| rateem2	      |
| ratemybeer	      |
| rcorona	      |
| readymedi	      |
| redlightcameras     |
| restaurant	      |
| rgordon	      |
| rgrewal	      |
| rhymez	      |
| rkhosa	      |
| rmanzo	      |
| rmojica	      |
| rmoreno	      |
| rocket_power	      |
| rpatel	      |
| rplascencia	      |
| rrivasnavarr	      |
| runnerpp	      |
| rvelasco	      |
| rvelasquez	      |
| rverduzcogui	      |
| rwyatt	      |
| sabdulrazzak	      |
| sarboleda	      |
| scarlos	      |
| scribble	      |
| sdenney	      |
| sdms		      |
| seniorpro23	      |
| sercoli	      |
| sesquivel	      |
| sflores	      |
| sgonzales	      |
| sgutierrez	      |
| sjue		      |
| skaing	      |
| skumar	      |
| skurtz	      |
| sledwell	      |
| sleep_tracker       |
| slithermaze	      |
| smahal	      |
| smayfieldsmi	      |
| smclaughlin	      |
| smonungolh	      |
| snez		      |
| sparksocial	      |
| srasapatirat	      |
| ssingh	      |
| sstewart	      |
| stay_fresh	      |
| stellez	      |
| steve 	      |
| stran 	      |
| subscriptions       |
| svargas	      |
| swilkerson	      |
| tbrown	      |
| teamo7	      |
| temptest	      |
| testing	      |
| themoviebuffs       |
| thermofrost	      |
| thooser	      |
| thousandiq	      |
| thriftstore	      |
| timesheet	      |
| tradespace	      |
| ufcdb 	      |
| ultraar	      |
| unreliablenarrator  |
| useraccountsdemo    |
| usingh	      |
| vfigueroa	      |
| vle		      |
| vto		      |
| walkmen	      |
| xreyes	      |
| ybond 	      |
| zenquest	      |
| zgarcia	      |
+---------------------+
B386 rows in set (0.003 sec)
BB
BMariaDB [nick]> use nick;
BDatabase changed
BMariaDB [nick]> usewcompanyf24;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BDatabase changed
BMariaDB [companyf24]> show tables;
+----------------------+
| Tables_in_companyf24 |
+----------------------+
| Department	       |
| DepartmentLocations  |
| Dependent	       |
| Employee	       |
| Project	       |
| WorksOn	       |
+----------------------+
B6 rows in set (0.000 sec)
BB
BMariaDB [companyf24]> describeeDepartment;
+------------------+-------------+------+-----+---------+----------------+
| Field 	   | Type	 | Null | Key | Default | Extra 	 |
+------------------+-------------+------+-----+---------+----------------+
| Dnumber	   | int(11)	 | NO	| PRI | NULL	| auto_increment |
| Dname 	   | varchar(50) | NO	|     | NULL	|		 |
| ManagerSSN	   | varchar(11) | NO	| MUL | NULL	|		 |
| ManagerStartDate | date	 | YES	|     | NULL	|		 |
+------------------+-------------+------+-----+---------+----------------+
B4 rows in set (0.001 sec)
BB
BMariaDB [companyf24]> show create table Department;
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table      | Create Table																																																									|
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Department | CREATE TABLE `Department` (
  `Dnumber` int(11) NOT NULL AUTO_INCREMENT,
  `Dname` varchar(50) NOT NULL CHECK (`Dname` <> ''),
  `ManagerSSN` varchar(11) NOT NULL,
  `ManagerStartDate` date DEFAULT NULL,
  PRIMARY KEY (`Dnumber`),
  KEY `ManagerSSN` (`ManagerSSN`),
  CONSTRAINT `Department_ibfk_1` FOREIGN KEY (`ManagerSSN`) REFERENCES `Employee` (`SSN`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `ENCRYPTION_KEY_ID`=100 |
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
B1 row in set (0.000 sec)
BB
BMariaDB [companyf24]> use nick;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BDatabase changed
BMariaDB [nick]> create table demo (col1 int);
BQuery OK, 0 rows affected (0.005 sec)
BB
BMariaDB [nick]> select * from demo;
BEmpty set (0.001 sec)
BB
BMariaDB [nick]> insert into demo values (1);
BQuery OK, 1 row affected (0.001 sec)
BB
selectD* fromkdemo;sert into demo values (1);
+------+
| col1 |
+------+
|    1 |
+------+
B1 row in set (0.000 sec)
BB
insertDintoidemo values 2),;(3),;(4);
BQuery OK, 3 rows affected (0.001 sec)
BBRecords: 3  Duplicates: 0  Warnings: 0
BB
selectD* fromkdemo;sert into demo values (2), (3), (4);
+------+
| col1 |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
+------+
B4 rows in set (0.000 sec)
BB
BMariaDB [nick]> drop table demo;
BQuery OK, 0 rows affected (0.003 sec)
BB
Bvarchar(50)c);> create tableedemo (id int primary key auto_increment, name
BQuery OK, 0 rows affected (0.004 sec)
BB
BMariaDB [nick]> describe demo;
+-------+-------------+------+-----+---------+----------------+
| Field | Type	      | Null | Key | Default | Extra	      |
+-------+-------------+------+-----+---------+----------------+
| id	| int(11)     | NO   | PRI | NULL    | auto_increment |
| name	| varchar(50) | YES  |	   | NULL    |		      |
+-------+-------------+------+-----+---------+----------------+
B2 rows in set (0.002 sec)
BB
as"),a("here");> insert into demo (name) valuess("nick"), ("toothman"), ("w
BQuery OK, 4 rows affected (0.001 sec)
BBRecords: 4  Duplicates: 0  Warnings: 0
BB
BMariaDB [nick]> select * from demo;
+----+----------+
| id | name	|
+----+----------+
|  1 | nick	|
|  2 | toothman |
|  3 | was	|
|  4 | here	|
+----+----------+
B4 rows in set (0.000 sec)
BB
BMariaDB [nick]> insert into demo values (1, "haha");
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
BBMariaDB [nick]> insert into demo values (109"haha");
BQuery OK, 1 row affected (0.001 sec)
BB
selectD* fromkdemo;sert into demo values (10, "haha");
+----+----------+
| id | name	|
+----+----------+
|  1 | nick	|
|  2 | toothman |
|  3 | was	|
|  4 | here	|
| 10 | haha	|
+----+----------+
B5 rows in set (0.001 sec)
BB
insertDintoidemo (name) valuesh("what happens?");
BQuery OK, 1 row affected (0.001 sec)
BB
selectD* fromkdemo;sert into demo (name) values ("what happens?");
+----+---------------+
| id | name	     |
+----+---------------+
|  1 | nick	     |
|  2 | toothman      |
|  3 | was	     |
|  4 | here	     |
| 10 | haha	     |
| 11 | what happens? |
+----+---------------+
B6 rows in set (0.001 sec)
BB
insertDinyeah!");;;;;;;;values ("what happens?");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
BBMariaDB [nick]> insert into demo (id, name) values (5,""yeah!");
BQuery OK, 1 row affected (0.001 sec)
BB
selectD* fromkdemo;sert into demo (id, name) values ("yeah!");");
+----+---------------+
| id | name	     |
+----+---------------+
|  1 | nick	     |
|  2 | toothman      |
|  3 | was	     |
|  4 | here	     |
|  5 | yeah!	     |
| 10 | haha	     |
| 11 | what happens? |
+----+---------------+
B7 rows in set (0.000 sec)
BB
BMariaDB [nick]> exit
BBye
Bnick@artemis:~$ mysql -p nick
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BWelcome to the MariaDB monitor.  Commands end with ; or \g.
BBYour MariaDB connection id is 45909
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10

BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

BMariaDB [nick]> exit
BBye
Bnick@artemis:~$ ls -l
total 264
drwx------ 12 nick nick   4096 Sep 13 12:58 3420
-rwxr-xr-x  1 nick nick 209512 Mar 14  2024 3420_trivia
drwx------ 15 nick nick   4096 Sep 13 13:00 4420
drwx------  3 nick nick   4096 Apr 22 14:13 backups
drwx------  3 nick nick   4096 Feb 28  2024 company_3420
drwx------  2 nick nick   4096 Apr 22 14:05 company_database
drwx------  7 nick nick   4096 Sep 20 12:41 misc
-rw-r--r--  1 nick nick     63 Oct  9  2023 my.cnf
drwx------  3 nick nick   4096 Mar  6  2023 prev
drwx------  2 nick nick   4096 Feb 28  2024 public
drwxr-xr-x 13 nick nick   4096 Sep  4 16:09 public_html
drwxr-xr-x  2 nick nick   4096 Sep 13 12:59 scripts
drwx------  2 nick nick   4096 Mar 14  2024 sql_lab
drwx------  8 nick nick   4096 Sep 23 16:34 src
drwx------  7 nick nick   4096 May 16 01:33 tmp
nick@artemis:~$ ls -al
total 1120
drwxr-xr-x 21 nick nick   4096 Oct  2 14:03 .
drwxr-xr-x  4 root root   4096 Nov  7  2022 ..
drwx------ 12 nick nick   4096 Sep 13 12:58 3420
-rwxr-xr-x  1 nick nick 209512 Mar 14  2024 3420_trivia
drwx------ 15 nick nick   4096 Sep 13 13:00 4420
drwx------  3 nick nick   4096 Apr 22 14:13 backups
-rw-------  1 nick nick 205576 Sep 30 12:43 .bash_history
-rw-r--r--  1 nick nick    220 Apr 17  2019 .bash_logout
-rw-r--r--  1 nick nick   3558 Feb 17  2023 .bashrc
drwx------  3 nick nick   4096 Feb 28  2024 company_3420
drwx------  2 nick nick   4096 Apr 22 14:05 company_database
drwx------  3 nick nick   4096 Oct 12  2021 .config
-rw-r--r--  1 nick nick     86 Nov 11  2021 .db-config.ini
-rw-r--r--  1 nick nick     33 Nov 11  2021 .gitconfig
drwx------  3 nick nick   4096 Sep 28  2021 .gnupg
-rw-r--r--  1 nick nick     63 Nov 21  2022 .inputrc
-rw-------  1 nick nick     85 Apr  2  2024 .lesshst
drwx------  7 nick nick   4096 Sep 20 12:41 misc
-rw-------  1 nick nick    107 Apr 17 17:40 .my.cnf
-rw-r--r--  1 nick nick     63 Oct  9  2023 my.cnf
-rw-------  1 nick nick 418358 Oct  2 14:03 .mysql_history
drwx------  3 nick nick   4096 Mar 28  2022 .old
-rw-------  1 nick nick  47962 Sep 30 12:28 .php_history
drwx------  3 nick nick   4096 Mar  6  2023 prev
-rw-r--r--  1 nick nick    807 Apr 17  2019 .profile
-rw-------  1 nick nick    146 Dec  7  2023 .psql_history
drwx------  2 nick nick   4096 Feb 28  2024 public
drwxr-xr-x 13 nick nick   4096 Sep  4 16:09 public_html
-rw-------  1 nick nick   9241 Sep 23 16:38 .python_history
drwxr-xr-x  2 nick nick   4096 Sep 13 12:59 scripts
-rw-r--r--  1 nick nick     74 Nov 30  2023 .selected_editor
-rw-------  1 nick nick  68225 Dec 11  2023 .sqlite_history
-rw-r--r--  1 nick nick     24 Mar 13  2023 .sqliterc
drwx------  2 nick nick   4096 Mar 14  2024 sql_lab
drwx------  8 nick nick   4096 Sep 23 16:34 src
drwx------  2 nick nick   4096 May  9 14:45 .ssh
drwx------  7 nick nick   4096 May 16 01:33 tmp
drwxr-xr-x  2 nick nick   4096 Sep 17 15:08 .vim
-rw-------  1 nick nick  24342 Sep 24 17:58 .viminfo
-rw-------  1 nick nick   2192 Nov 11  2021 .vimrc
drwxr-xr-x  2 nick nick   4096 Nov 17  2022 .vscode
-rw-r--r--  1 nick nick    215 Mar 11  2024 .wget-hsts
nick@artemis:~$ cat my.cnf
[mysql]
user=
database=
password=

[mysqldump]
user=
password=
ehok@artemis:~$ cp ~nick/my.cnf ~/.my.cnf
cp /home/fac/nick/my.cnf /home/fac/nick/.my.cnf
nick@artemis:~$ chmod 600 .my.cnf
nick@artemis:~$ mysqlmy.cnf
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BWelcome to the MariaDB monitor.  Commands end with ; or \g.
BBYour MariaDB connection id is 45930
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10

BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

BMariaDB [nick]> exit
BBye
Bnick@artemis:~$ exit
logout
Connection to artemis.cs.csub.edu closed.
nick@Vaxis:~$ exit
exit