nick@Vaxis:~$ ssh artemis Linux artemis 4.19.0-18-amd64 #1 SMP Debian 4.19.208-1 (2021-09-29) 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: Fri Apr 28 14:00:51 2023 from 136.168.36.190 nick@artemis:~$ cd 3420 nick@artemis:~/3420$ ls -l total 272 -rwxr-xr-x 1 nick nick 209512 Oct 24 2022 3420_trivia drwxr-xr-x 6 nick nick 4096 Mar 6 13:00 company drwx------ 2 nick nick 4096 Oct 10 2022 company_tmp -rw-r--r-- 1 nick nick 15459 Mar 16 13:29 create_Employee.sql -rw-r--r-- 1 nick nick 6296 Mar 16 13:27 Employee.csv -rwxr-xr-x 1 nick nick 2024 Mar 16 13:29 insertgenerator_v2.py drwxr-xr-x 2 nick nick 4096 Mar 30 13:03 lab8 drwx------ 4 nick nick 4096 Mar 9 12:39 prev drwxr-xr-x 3 nick nick 4096 Mar 30 13:03 s23 drwx------ 2 nick nick 4096 Apr 16 20:06 scripts -rwxr-xr-x 1 nick nick 1950 Apr 16 20:06 update_password.py -rw-r--r-- 1 nick nick 1959 Apr 16 20:06 update_pw.php drwxr-xr-x 5 nick nick 4096 Dec 12 22:15 useraccountsdemo nick@artemis:~/3420$ mysql sparksocial 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 2362 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 [sparksocial]> select * from users; +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+----------+ | uID | email | Plaintext | username | datejoin | bio | profilepic | Password | +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+----------+ | 999998 | lmk7@gmail.com | 123456 | lmk7 | 2023-04-27 | | | NULL | | 999999 | lmk3@gmail.com | 123456 | lmk3 | 2023-04-27 | | | NULL | | 4234234 | nick@cs | test | nick | 2023-04-28 | test | test | NULL | | 7777777 | father77777777@gmail.com | Good777777 | God777 | 2023-04-07 | God | image_6655763.userspng | NULL | | 99999888 | lmk78@gmail.com | 123456 | lmk78 | 2023-04-27 | | | NULL | | 253947753 | kkerbler2@edublogs.org | la1kr2 | hcamosso2 | 2022-01-30 | NULL | image_7478382.userspng | NULL | | 427260011 | lsoame7@printfriendly.com | wUosEo | lvasyagin7 | 2022-11-02 | NULL | NULL | NULL | | 469468686 | ipobjoy9@nature.com | AYPCUpBDMk | mbarrowclough9 | 2022-10-11 | NULL | NULL | NULL | | 611957801 | rpease1@miibeian.gov.cn | cunOoMQAWayS | plindenbaum1 | 2021-02-23 | NULL | image_9584930.userspng | NULL | | 689852130 | tjacquemot6@is.gd | 0JhbIsd | eekell6 | 2021-07-04 | NULL | image_7384939.userspng | NULL | | 701938571 | aslfjasl34053405943593@gmail.com | test | Joseph | 2023-04-20 | | image_9888493.userspng | NULL | | 701938572 | what@ever.com | whatever | Joe | NULL | | image_98293993.userspng | NULL | | 771542694 | agrigorkin3@technorati.com | E0OMLF6 | lgrimsdyke3 | 2022-06-27 | NULL | NULL | NULL | | 804343357 | adorrell8@dion.ne.jp | SDy0SIc5E0 | mbruckshaw8 | 2022-01-31 | NULL | NULL | NULL | | 891111331 | djefford4@dell.com | YzqFNcXEx | cmantripp4 | 2022-09-25 | NULL | images/test.png | NULL | | 891111332 | lmk@lmk.com | password123 | lmk | 2023-04-27 | NULL | NULL | NULL | +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+----------+ B16 rows in set (0.000 sec) BB BMariaDB [sparksocial]> [1]+ Stopped mysql sparksocial nick@artemis:~/3420$ php update_pw.php Enter username: nick Enter Password: Enter database: sparksocials Array ( [Tables_in_sparksocial] => Canchat ) Array ( [Tables_in_sparksocial] => Canfriend ) Array ( [Tables_in_sparksocial] => Content ) Array ( [Tables_in_sparksocial] => Permissions ) Array ( [Tables_in_sparksocial] => users ) Enter a table name: users Description of columns in users Field: uID, Type: int(9) Field: email, Type: varchar(60) Field: Plaintext, Type: varchar(60) Field: username, Type: varchar(15) Field: datejoin, Type: date Field: bio, Type: varchar(100) Field: profilepic, Type: varchar(100) Field: Password, Type: varchar(60) Enter a column to represent the primary key: uID Enter a column name to run through password_hash: ^C nick@artemis:~/3420$ fg mysql sparksocial MariaDB [sparksocial]> update usersmsetePassword = Plaintext; BQuery OK, 16 rows affected (0.002 sec) BBRows matched: 16 Changed: 16 Warnings: 0 BB BMariaDB [sparksocial]> select * from users; +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+--------------+ | uID | email | Plaintext | username | datejoin | bio | profilepic | Password | +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+--------------+ | 999998 | lmk7@gmail.com | 123456 | lmk7 | 2023-04-27 | | | 123456 | | 999999 | lmk3@gmail.com | 123456 | lmk3 | 2023-04-27 | | | 123456 | | 4234234 | nick@cs | test | nick | 2023-04-28 | test | test | test | | 7777777 | father77777777@gmail.com | Good777777 | God777 | 2023-04-07 | God | image_6655763.userspng | Good777777 | | 99999888 | lmk78@gmail.com | 123456 | lmk78 | 2023-04-27 | | | 123456 | | 253947753 | kkerbler2@edublogs.org | la1kr2 | hcamosso2 | 2022-01-30 | NULL | image_7478382.userspng | la1kr2 | | 427260011 | lsoame7@printfriendly.com | wUosEo | lvasyagin7 | 2022-11-02 | NULL | NULL | wUosEo | | 469468686 | ipobjoy9@nature.com | AYPCUpBDMk | mbarrowclough9 | 2022-10-11 | NULL | NULL | AYPCUpBDMk | | 611957801 | rpease1@miibeian.gov.cn | cunOoMQAWayS | plindenbaum1 | 2021-02-23 | NULL | image_9584930.userspng | cunOoMQAWayS | | 689852130 | tjacquemot6@is.gd | 0JhbIsd | eekell6 | 2021-07-04 | NULL | image_7384939.userspng | 0JhbIsd | | 701938571 | aslfjasl34053405943593@gmail.com | test | Joseph | 2023-04-20 | | image_9888493.userspng | test | | 701938572 | what@ever.com | whatever | Joe | NULL | | image_98293993.userspng | whatever | | 771542694 | agrigorkin3@technorati.com | E0OMLF6 | lgrimsdyke3 | 2022-06-27 | NULL | NULL | E0OMLF6 | | 804343357 | adorrell8@dion.ne.jp | SDy0SIc5E0 | mbruckshaw8 | 2022-01-31 | NULL | NULL | SDy0SIc5E0 | | 891111331 | djefford4@dell.com | YzqFNcXEx | cmantripp4 | 2022-09-25 | NULL | images/test.png | YzqFNcXEx | | 891111332 | lmk@lmk.com | password123 | lmk | 2023-04-27 | NULL | NULL | password123 | +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+--------------+ B16 rows in set (0.001 sec) BB BMariaDB [sparksocial]> ex [1]+ Stopped mysql sparksocial nick@artemis:~/3420$ php update_pw.php Enter username: nick Enter Password: Enter database: sparksocial Array ( [Tables_in_sparksocial] => Canchat ) Array ( [Tables_in_sparksocial] => Canfriend ) Array ( [Tables_in_sparksocial] => Content ) Array ( [Tables_in_sparksocial] => Permissions ) Array ( [Tables_in_sparksocial] => users ) Enter a table name: users Description of columns in users Field: uID, Type: int(9) Field: email, Type: varchar(60) Field: Plaintext, Type: varchar(60) Field: username, Type: varchar(15) Field: datejoin, Type: date Field: bio, Type: varchar(100) Field: profilepic, Type: varchar(100) Field: Password, Type: varchar(60) Enter a column to represent the primary key: uID Enter a column name to run through password_hash: Password Press enter to show users contents (16 rows): 999998: 123456 -> $2y$10$YNAsr18.NjuwE4ewKjNzdeF0lDRIOzEMm7v4lqQoUhqRFhdl8GE8G 999999: 123456 -> $2y$10$M.908OOmp9YvEOiwWg0IJO5nC.MbPlIYOYuKkXRlTOnH/LOuxAl.C 4234234: test -> $2y$10$r9zeAcKZjAdBDWdc4qmERuIieup.G1pY82x5DAbZhZ7IlafCb54y6 7777777: Good777777 -> $2y$10$tGUIs/nnLnS0yDMMrZ3o3ergMqqfTi4alUhPr9oBR0YAs4YzV7jLm 99999888: 123456 -> $2y$10$yAAAi0Rvne6NkpYlK/noTeKhizbd5j7nhU7zdY1pow3QFqD/YnbSW 253947753: la1kr2 -> $2y$10$h4npllq/aOBVrCD4MNT0ue73D7CaURhkNDkv9s/YIFXaS6CqIp5ua 427260011: wUosEo -> $2y$10$5hE2gva8fmNBhobYMletqe14F/rRkBeugjXznswSOn6RRBWEH2aP2 469468686: AYPCUpBDMk -> $2y$10$ajhVQqDW8OzSQdzRF6XY4ekIz6RVl0T0/Ozhu7NiV9jm9S12Elf5G 611957801: cunOoMQAWayS -> $2y$10$dQiidI6zq70Mvwul5vv5IuZoJT4V4aO0PbIedZzgzUqm8RByMBbLy 689852130: 0JhbIsd -> $2y$10$ZA11DC9UkHK7Ua5ezJgRCeTH2Nn46spl14AxIvAp9gG0kg/oPasYi 701938571: test -> $2y$10$S/FPIUj9cjBV/v/Xo27B0eZRxffX/1OPdNCtQ/Lvgk3/ngHCMagTi 701938572: whatever -> $2y$10$grM/.ACHMC2zMuzJDwKiWevWW3I.w.ID16nCi2.aXWu36fIDBpfoq 771542694: E0OMLF6 -> $2y$10$din1TgWxEx1DND4k4I/FCO9Tkqw0WQTeXO0TT3IC.NtyMCkrTxCQC 804343357: SDy0SIc5E0 -> $2y$10$L2uCvXiDSok7W/Pby964FuSnG6xCO8fsW2A3Skb0L75LEAGEYk7sq 891111331: YzqFNcXEx -> $2y$10$29B55BSzhwhP/Yqm54vjke0IITV4XG/9GdDaFikuwhrXREMYtBF9O 891111332: password123 -> $2y$10$JJEWVAdaEwkgB5PQwTzmAOE46WNgL5PuYPHTRxYDdIoB1X0ecuS.m nick@artemis:~/3420$ fg mysql sparksocial selectB*[fromkusers;]> update usersmsetePassword = Plaintext; +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+--------------------------------------------------------------+ | uID | email | Plaintext | username | datejoin | bio | profilepic | Password | +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+--------------------------------------------------------------+ | 999998 | lmk7@gmail.com | 123456 | lmk7 | 2023-04-27 | | | $2y$10$YNAsr18.NjuwE4ewKjNzdeF0lDRIOzEMm7v4lqQoUhqRFhdl8GE8G | | 999999 | lmk3@gmail.com | 123456 | lmk3 | 2023-04-27 | | | $2y$10$M.908OOmp9YvEOiwWg0IJO5nC.MbPlIYOYuKkXRlTOnH/LOuxAl.C | | 4234234 | nick@cs | test | nick | 2023-04-28 | test | test | $2y$10$r9zeAcKZjAdBDWdc4qmERuIieup.G1pY82x5DAbZhZ7IlafCb54y6 | | 7777777 | father77777777@gmail.com | Good777777 | God777 | 2023-04-07 | God | image_6655763.userspng | $2y$10$tGUIs/nnLnS0yDMMrZ3o3ergMqqfTi4alUhPr9oBR0YAs4YzV7jLm | | 99999888 | lmk78@gmail.com | 123456 | lmk78 | 2023-04-27 | | | $2y$10$yAAAi0Rvne6NkpYlK/noTeKhizbd5j7nhU7zdY1pow3QFqD/YnbSW | | 253947753 | kkerbler2@edublogs.org | la1kr2 | hcamosso2 | 2022-01-30 | NULL | image_7478382.userspng | $2y$10$h4npllq/aOBVrCD4MNT0ue73D7CaURhkNDkv9s/YIFXaS6CqIp5ua | | 427260011 | lsoame7@printfriendly.com | wUosEo | lvasyagin7 | 2022-11-02 | NULL | NULL | $2y$10$5hE2gva8fmNBhobYMletqe14F/rRkBeugjXznswSOn6RRBWEH2aP2 | | 469468686 | ipobjoy9@nature.com | AYPCUpBDMk | mbarrowclough9 | 2022-10-11 | NULL | NULL | $2y$10$ajhVQqDW8OzSQdzRF6XY4ekIz6RVl0T0/Ozhu7NiV9jm9S12Elf5G | | 611957801 | rpease1@miibeian.gov.cn | cunOoMQAWayS | plindenbaum1 | 2021-02-23 | NULL | image_9584930.userspng | $2y$10$dQiidI6zq70Mvwul5vv5IuZoJT4V4aO0PbIedZzgzUqm8RByMBbLy | | 689852130 | tjacquemot6@is.gd | 0JhbIsd | eekell6 | 2021-07-04 | NULL | image_7384939.userspng | $2y$10$ZA11DC9UkHK7Ua5ezJgRCeTH2Nn46spl14AxIvAp9gG0kg/oPasYi | | 701938571 | aslfjasl34053405943593@gmail.com | test | Joseph | 2023-04-20 | | image_9888493.userspng | $2y$10$S/FPIUj9cjBV/v/Xo27B0eZRxffX/1OPdNCtQ/Lvgk3/ngHCMagTi | | 701938572 | what@ever.com | whatever | Joe | NULL | | image_98293993.userspng | $2y$10$grM/.ACHMC2zMuzJDwKiWevWW3I.w.ID16nCi2.aXWu36fIDBpfoq | | 771542694 | agrigorkin3@technorati.com | E0OMLF6 | lgrimsdyke3 | 2022-06-27 | NULL | NULL | $2y$10$din1TgWxEx1DND4k4I/FCO9Tkqw0WQTeXO0TT3IC.NtyMCkrTxCQC | | 804343357 | adorrell8@dion.ne.jp | SDy0SIc5E0 | mbruckshaw8 | 2022-01-31 | NULL | NULL | $2y$10$L2uCvXiDSok7W/Pby964FuSnG6xCO8fsW2A3Skb0L75LEAGEYk7sq | | 891111331 | djefford4@dell.com | YzqFNcXEx | cmantripp4 | 2022-09-25 | NULL | images/test.png | $2y$10$29B55BSzhwhP/Yqm54vjke0IITV4XG/9GdDaFikuwhrXREMYtBF9O | | 891111332 | lmk@lmk.com | password123 | lmk | 2023-04-27 | NULL | NULL | $2y$10$JJEWVAdaEwkgB5PQwTzmAOE46WNgL5PuYPHTRxYDdIoB1X0ecuS.m | +-----------+----------------------------------+--------------+----------------+------------+------+-------------------------+--------------------------------------------------------------+ B16 rows in set (0.001 sec) BB BMariaDB [sparksocial]> exit BBye Bnick@artemis:~/3420$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ exit exit