nick@artemis:~$ cd public_html/3420/auth/
nick@artemis:~/public_html/3420/auth$ ls -l
total 28
-rw-r--r-- 1 nick nick 623 Apr 9 14:12 api.php
-rw-r--r-- 1 nick nick 2378 Apr 7 13:31 config.php
-rw-r--r-- 1 nick nick 462 Apr 9 13:42 db.sql
-rw-r--r-- 1 nick nick 2011 Apr 9 14:17 index.php
-rw-r--r-- 1 nick nick 1411 Apr 9 13:12 login.php
-rw-r--r-- 1 nick nick 324 Apr 7 14:01 logout.php
-rw-r--r-- 1 nick nick 849 Apr 9 13:12 register.php
nick@artemis:~/public_html/3420/auth$ mysql auth_demo;
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 29765
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 [auth_demo]> show tables;
+---------------------+
| Tables_in_auth_demo |
+---------------------+
| Person |
| chat |
| chatmessages |
+---------------------+
B3 rows in set (0.000 sec)
BB
BMariaDB [auth_demo]> show create table Person;
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Person | CREATE TABLE `Person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(30) DEFAULT NULL,
`password` varchar(60) DEFAULT NULL,
`createdon` datetime DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `ENCRYPTION_KEY_ID`=100 |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
B1 row in set (0.000 sec)
BB
00);defaultunu_demo]> alter table Person add column profilepic varchar(1
BQuery OK, 0 rows affected (0.038 sec)
BBRecords: 0 Duplicates: 0 Warnings: 0
BB
BMariaDB [auth_demo]> show create table Person;
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Person | CREATE TABLE `Person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(30) DEFAULT NULL,
`password` varchar(60) DEFAULT NULL,
`createdon` datetime DEFAULT current_timestamp(),
`profilepic` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `ENCRYPTION_KEY_ID`=100 |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
B1 row in set (0.000 sec)
BB
BMariaDB [auth_demo]>
[1]+ Stopped mysql auth_demo
nick@artemis:~/public_html/3420/auth$ ls -l
total 32
-rw-r--r-- 1 nick nick 623 Apr 9 14:12 api.php
-rw-r--r-- 1 nick nick 2378 Apr 7 13:31 config.php
-rw-r--r-- 1 nick nick 462 Apr 9 13:42 db.sql
-rw-r--r-- 1 nick nick 2011 Apr 9 14:17 index.php
-rw-r--r-- 1 nick nick 1411 Apr 9 13:12 login.php
-rw-r--r-- 1 nick nick 324 Apr 7 14:01 logout.php
-rw-r--r-- 1 nick nick 763 Apr 21 14:00 profile.php
-rw-r--r-- 1 nick nick 849 Apr 9 13:12 register.php
nick@artemis:~/public_html/3420/auth$ mkdir profile_pics;
nick@artemis:~/public_html/3420/auth$ fg
mysql auth_demo
MariaDB [auth_demo]> select * from Person;
+----+----------------------+--------------------------------------------------------------+---------------------+------------+
| id | username | password | createdon | profilepic |
+----+----------------------+--------------------------------------------------------------+---------------------+------------+
| 7 | nick | $2y$10$PA.jxifNBtEqE2KSU9DZGOJzaXlDIWydoESNQ.1whRM1MFAGP7.lW | 2025-04-09 13:12:53 | NULL |
| 8 | nano | $2y$10$SFEULBbf9FbFIAfBJ6bhbelkabe3wrTIcX97jicT23up.I.UZ85bS | 2025-04-09 13:48:17 | NULL |
| 9 | tim | $2y$10$xD9iAZFSeO.QPK4xd4dw3Ot5YHkdXn4zGHbg5YEfpvm5Bf.v8K/FO | 2025-04-09 13:48:52 | NULL |
| 10 | Henry | $2y$10$PKg/khdogG0gTEFNlfnGsuUTk18/lKbI/keZsaHaYBEX9V//SjZ7W | 2025-04-09 13:48:55 | NULL |
| 11 | falrowhani | $2y$10$knIhDT3VzI8DUvKZYhTE0eAbBX8VZoYu1l8Fc8wFPtlTbkaMdrHnO | 2025-04-09 13:49:00 | NULL |
| 12 | terry | $2y$10$St1hR.Ao7LQ/FyrgPSvZwOd23bS2eftl2hnMN6DUowL3s1I9.QA.G | 2025-04-09 13:49:09 | NULL |
| 13 | fenoon | $2y$10$62HAjF5tAu.S98QTKICnNOwHgA5OCkkqLjut0WrzTNkWEZlPIvHT2 | 2025-04-09 13:49:24 | NULL |
| 14 | jsifuentes5@csub.edu | $2y$10$vTE37r1EUfYHb1sw.a6ft.trmYQergQNPnnbxYw75k/RelwYGBwHy | 2025-04-09 13:49:27 | NULL |
| 15 | Shrek | $2y$10$2U7Ja5JAuw9N9.MDmEP0ke0j7EmmuqjyxSeWCd/oR3gvwiRWq3iMu | 2025-04-09 13:49:30 | NULL |
| 16 | monique | $2y$10$mnq88jhTYYeTlpyBei9.PunLKb3ELauQ5.53dEqaiwqn8iGFBIhjS | 2025-04-09 13:49:35 | NULL |
| 17 | yessica | $2y$10$RUnfXx/MWe3mfhFsj3uUFuNl6vvc/sXDDKimmWAGFJW74iFO/UWwO | 2025-04-09 13:49:49 | NULL |
| 18 | George | $2y$10$RJk7yVCvpqtBFkJ3uye65.xpWE.TIIg0JYKKDP0uYPFUjVThGgWhW | 2025-04-09 13:49:52 | NULL |
| 19 | Donkey | $2y$10$iOm1S7AfwL.ioee61GkR0.W0g.Pg9k5cMYirVzKH/3mgpWHGddOqu | 2025-04-09 13:51:23 | NULL |
| 20 | USA | $2y$10$Stl16ImqC1CZR2dVwNux.OsfubNrZPSmW0ABTSaOZGJn39nzM083u | 2025-04-09 13:51:53 | NULL |
| 21 | notnick | $2y$10$1D8OKQwwB54eh6Ovu.sjM.N8OrcDG.Py2c0JQaoCeKHRD1LOZddYG | 2025-04-09 13:58:22 | NULL |
| 22 | Bdarghali@csub.edu | $2y$10$u7grdGeLAXAYDm9NENqSsOfs61tICtoYkiHtMjQrGsaafo8/0ZTd. | 2025-04-09 14:09:35 | NULL |
| 23 | banjo | $2y$10$Kn9GosV1UZNRdsHuoPAcNucvxTK1cX6x4LoUFK.qUyMwCB6JjY0fy | 2025-04-09 14:20:26 | NULL |
+----+----------------------+--------------------------------------------------------------+---------------------+------------+
B17 rows in set (0.000 sec)
BB
BMariaDB [auth_demo]> e
[1]+ Stopped mysql auth_demo
nick@artemis:~/public_html/3420/auth$ ls -l
total 36
-rw-r--r-- 1 nick nick 623 Apr 9 14:12 api.php
-rw-r--r-- 1 nick nick 2378 Apr 7 13:31 config.php
-rw-r--r-- 1 nick nick 462 Apr 9 13:42 db.sql
-rw-r--r-- 1 nick nick 2011 Apr 9 14:17 index.php
-rw-r--r-- 1 nick nick 1411 Apr 9 13:12 login.php
-rw-r--r-- 1 nick nick 324 Apr 7 14:01 logout.php
-rw-r--r-- 1 nick nick 914 Apr 21 14:07 profile.php
drwxr-xr-x 2 nick nick 4096 Apr 21 14:00 profile_pics
-rw-r--r-- 1 nick nick 849 Apr 9 13:12 register.php
nick@artemis:~/public_html/3420/auth$ chmod 757 profile_pics;
nick@artemis:~/public_html/3420/auth$ ls -l
total 36
-rw-r--r-- 1 nick nick 623 Apr 9 14:12 api.php
-rw-r--r-- 1 nick nick 2378 Apr 7 13:31 config.php
-rw-r--r-- 1 nick nick 462 Apr 9 13:42 db.sql
-rw-r--r-- 1 nick nick 2011 Apr 9 14:17 index.php
-rw-r--r-- 1 nick nick 1411 Apr 9 13:12 login.php
-rw-r--r-- 1 nick nick 324 Apr 7 14:01 logout.php
-rw-r--r-- 1 nick nick 914 Apr 21 14:07 profile.php
drwxr-xrwx 2 nick nick 4096 Apr 21 14:00 profile_pics
-rw-r--r-- 1 nick nick 849 Apr 9 13:12 register.php
nick@artemis:~/public_html/3420/auth$ fg
mysql auth_demo
MariaDB [auth_demo]> select * from Person;
+----+----------------------+--------------------------------------------------------------+---------------------+----------------------------------------------+
| id | username | password | createdon | profilepic |
+----+----------------------+--------------------------------------------------------------+---------------------+----------------------------------------------+
| 7 | nick | $2y$10$PA.jxifNBtEqE2KSU9DZGOJzaXlDIWydoESNQ.1whRM1MFAGP7.lW | 2025-04-09 13:12:53 | profile_pics/7_WIN_20250421_14_03_44_Pro.jpg |
| 8 | nano | $2y$10$SFEULBbf9FbFIAfBJ6bhbelkabe3wrTIcX97jicT23up.I.UZ85bS | 2025-04-09 13:48:17 | NULL |
| 9 | tim | $2y$10$xD9iAZFSeO.QPK4xd4dw3Ot5YHkdXn4zGHbg5YEfpvm5Bf.v8K/FO | 2025-04-09 13:48:52 | NULL |
| 10 | Henry | $2y$10$PKg/khdogG0gTEFNlfnGsuUTk18/lKbI/keZsaHaYBEX9V//SjZ7W | 2025-04-09 13:48:55 | NULL |
| 11 | falrowhani | $2y$10$knIhDT3VzI8DUvKZYhTE0eAbBX8VZoYu1l8Fc8wFPtlTbkaMdrHnO | 2025-04-09 13:49:00 | NULL |
| 12 | terry | $2y$10$St1hR.Ao7LQ/FyrgPSvZwOd23bS2eftl2hnMN6DUowL3s1I9.QA.G | 2025-04-09 13:49:09 | NULL |
| 13 | fenoon | $2y$10$62HAjF5tAu.S98QTKICnNOwHgA5OCkkqLjut0WrzTNkWEZlPIvHT2 | 2025-04-09 13:49:24 | NULL |
| 14 | jsifuentes5@csub.edu | $2y$10$vTE37r1EUfYHb1sw.a6ft.trmYQergQNPnnbxYw75k/RelwYGBwHy | 2025-04-09 13:49:27 | NULL |
| 15 | Shrek | $2y$10$2U7Ja5JAuw9N9.MDmEP0ke0j7EmmuqjyxSeWCd/oR3gvwiRWq3iMu | 2025-04-09 13:49:30 | NULL |
| 16 | monique | $2y$10$mnq88jhTYYeTlpyBei9.PunLKb3ELauQ5.53dEqaiwqn8iGFBIhjS | 2025-04-09 13:49:35 | NULL |
| 17 | yessica | $2y$10$RUnfXx/MWe3mfhFsj3uUFuNl6vvc/sXDDKimmWAGFJW74iFO/UWwO | 2025-04-09 13:49:49 | NULL |
| 18 | George | $2y$10$RJk7yVCvpqtBFkJ3uye65.xpWE.TIIg0JYKKDP0uYPFUjVThGgWhW | 2025-04-09 13:49:52 | NULL |
| 19 | Donkey | $2y$10$iOm1S7AfwL.ioee61GkR0.W0g.Pg9k5cMYirVzKH/3mgpWHGddOqu | 2025-04-09 13:51:23 | NULL |
| 20 | USA | $2y$10$Stl16ImqC1CZR2dVwNux.OsfubNrZPSmW0ABTSaOZGJn39nzM083u | 2025-04-09 13:51:53 | NULL |
| 21 | notnick | $2y$10$1D8OKQwwB54eh6Ovu.sjM.N8OrcDG.Py2c0JQaoCeKHRD1LOZddYG | 2025-04-09 13:58:22 | NULL |
| 22 | Bdarghali@csub.edu | $2y$10$u7grdGeLAXAYDm9NENqSsOfs61tICtoYkiHtMjQrGsaafo8/0ZTd. | 2025-04-09 14:09:35 | NULL |
| 23 | banjo | $2y$10$Kn9GosV1UZNRdsHuoPAcNucvxTK1cX6x4LoUFK.qUyMwCB6JjY0fy | 2025-04-09 14:20:26 | NULL |
+----+----------------------+--------------------------------------------------------------+---------------------+----------------------------------------------+
B17 rows in set (0.000 sec)
BB
BMariaDB [auth_demo]> select * from Person;
+----+----------------------+--------------------------------------------------------------+---------------------+----------------------------------------------+
| id | username | password | createdon | profilepic |
+----+----------------------+--------------------------------------------------------------+---------------------+----------------------------------------------+
| 7 | nick | $2y$10$PA.jxifNBtEqE2KSU9DZGOJzaXlDIWydoESNQ.1whRM1MFAGP7.lW | 2025-04-09 13:12:53 | profile_pics/7_WIN_20241126_14_04_31_Pro.jpg |
| 8 | nano | $2y$10$SFEULBbf9FbFIAfBJ6bhbelkabe3wrTIcX97jicT23up.I.UZ85bS | 2025-04-09 13:48:17 | NULL |
| 9 | tim | $2y$10$xD9iAZFSeO.QPK4xd4dw3Ot5YHkdXn4zGHbg5YEfpvm5Bf.v8K/FO | 2025-04-09 13:48:52 | NULL |
| 10 | Henry | $2y$10$PKg/khdogG0gTEFNlfnGsuUTk18/lKbI/keZsaHaYBEX9V//SjZ7W | 2025-04-09 13:48:55 | NULL |
| 11 | falrowhani | $2y$10$knIhDT3VzI8DUvKZYhTE0eAbBX8VZoYu1l8Fc8wFPtlTbkaMdrHnO | 2025-04-09 13:49:00 | NULL |
| 12 | terry | $2y$10$St1hR.Ao7LQ/FyrgPSvZwOd23bS2eftl2hnMN6DUowL3s1I9.QA.G | 2025-04-09 13:49:09 | NULL |
| 13 | fenoon | $2y$10$62HAjF5tAu.S98QTKICnNOwHgA5OCkkqLjut0WrzTNkWEZlPIvHT2 | 2025-04-09 13:49:24 | NULL |
| 14 | jsifuentes5@csub.edu | $2y$10$vTE37r1EUfYHb1sw.a6ft.trmYQergQNPnnbxYw75k/RelwYGBwHy | 2025-04-09 13:49:27 | NULL |
| 15 | Shrek | $2y$10$2U7Ja5JAuw9N9.MDmEP0ke0j7EmmuqjyxSeWCd/oR3gvwiRWq3iMu | 2025-04-09 13:49:30 | NULL |
| 16 | monique | $2y$10$mnq88jhTYYeTlpyBei9.PunLKb3ELauQ5.53dEqaiwqn8iGFBIhjS | 2025-04-09 13:49:35 | NULL |
| 17 | yessica | $2y$10$RUnfXx/MWe3mfhFsj3uUFuNl6vvc/sXDDKimmWAGFJW74iFO/UWwO | 2025-04-09 13:49:49 | NULL |
| 18 | George | $2y$10$RJk7yVCvpqtBFkJ3uye65.xpWE.TIIg0JYKKDP0uYPFUjVThGgWhW | 2025-04-09 13:49:52 | NULL |
| 19 | Donkey | $2y$10$iOm1S7AfwL.ioee61GkR0.W0g.Pg9k5cMYirVzKH/3mgpWHGddOqu | 2025-04-09 13:51:23 | NULL |
| 20 | USA | $2y$10$Stl16ImqC1CZR2dVwNux.OsfubNrZPSmW0ABTSaOZGJn39nzM083u | 2025-04-09 13:51:53 | NULL |
| 21 | notnick | $2y$10$1D8OKQwwB54eh6Ovu.sjM.N8OrcDG.Py2c0JQaoCeKHRD1LOZddYG | 2025-04-09 13:58:22 | NULL |
| 22 | Bdarghali@csub.edu | $2y$10$u7grdGeLAXAYDm9NENqSsOfs61tICtoYkiHtMjQrGsaafo8/0ZTd. | 2025-04-09 14:09:35 | NULL |
| 23 | banjo | $2y$10$Kn9GosV1UZNRdsHuoPAcNucvxTK1cX6x4LoUFK.qUyMwCB6JjY0fy | 2025-04-09 14:20:26 | NULL |
+----+----------------------+--------------------------------------------------------------+---------------------+----------------------------------------------+
B17 rows in set (0.000 sec)
BB
BMariaDB [auth_demo]>
[1]+ Stopped mysql auth_demo
nick@artemis:~/public_html/3420/auth$ ls -l
total 36
-rw-r--r-- 1 nick nick 623 Apr 9 14:12 api.php
-rw-r--r-- 1 nick nick 2378 Apr 7 13:31 config.php
-rw-r--r-- 1 nick nick 462 Apr 9 13:42 db.sql
-rw-r--r-- 1 nick nick 2011 Apr 9 14:17 index.php
-rw-r--r-- 1 nick nick 1411 Apr 9 13:12 login.php
-rw-r--r-- 1 nick nick 324 Apr 7 14:01 logout.php
-rw-r--r-- 1 nick nick 1251 Apr 21 14:11 profile.php
drwxr-xrwx 2 nick nick 4096 Apr 21 14:11 profile_pics
-rw-r--r-- 1 nick nick 849 Apr 9 13:12 register.php
nick@artemis:~/public_html/3420/auth$ ls -l profile_pics/
total 108
-rw-r--r-- 1 www-data www-data 107041 Apr 21 14:14 7_WIN_20250421_14_03_44_Pro.jpg
nick@artemis:~/public_html/3420/auth$ exit
exit
There are stopped jobs.
nick@artemis:~/public_html/3420/auth$ exit
exit