Use mysql inside the cmd

  C:\xampp\mysql\bin>mysql -u root -p

 C:\xampp\mysql\bin>mysql -u root -p

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 2823

Server version: 10.4.24-MariaDB mariadb.org binary distribution

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

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

MariaDB [(none)]> show databases;

MariaDB [(none)]> show databases;

+---------------------+

| Database            |

+---------------------+

| ecommerce           |

| information_schema  |

| libra               |

| my                  |

| mysql               |

| mytestingdb         |

| performance_schema  |

| phpmyadmin          |

| physio              |

| prime-coach-backend |

| secret_potion       |

| sendmail            |

| socialite           |

| stripe_test         |

| test                |

| testing             |

| toolx               |

+---------------------+

17 rows in set (0.003 sec)

MariaDB [(none)]> use my Database changed

MariaDB [my]> show tables;

+------------------------+

| Tables_in_my           |

+------------------------+

| emails                 |

| failed_jobs            |

| fakes                  |

| fname                  |

| migrations             |

| password_resets        |

| personal_access_tokens |

| shirts                 |

| students               |

| testing                |

| testingtbl             |

| users                  |

+------------------------+

12 rows in set (0.001 sec)

MariaDB [my]> select * from testing;

+----+---------+--------+-------+---------------------+---------------------+

| id | fname   | lname  | email | created_at          | updated_at          |

+----+---------+--------+-------+---------------------+---------------------+

|  1 | Savanna | White  | NULL  | 2023-01-28 10:48:07 | 2023-01-28 10:48:49 |

|  2 | Seth    | Stokes | NULL  | 2023-01-28 10:48:07 | 2023-01-28 10:48:49 |

|  3 | Dominic | Auer   | NULL  | 2023-01-28 10:48:07 | 2023-01-28 10:48:49 |

|  4 | Millie  | Dicki  | NULL  | 2023-01-28 10:48:07 | 2023-01-28 10:48:49 |

|  5 | Brooks  | Funk   | NULL  | 2023-01-28 10:48:07 | 2023-01-28 10:48:49 |

+----+---------+--------+-------+---------------------+---------------------+

5 rows in set (0.000 sec)