Book Book edition 4. ch 9 GE securing an application. here bksecurity database does not include a users table..
[root@workstation ~]# mariadb -u bkadmin -p --protocol tcp
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.5.22-MariaDB MariaDB Server
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)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> show databases;
--------------------
--------------------
bksecurity |
information_schema |
--------------------
2 rows in set (0.003 sec)
MariaDB [(none)]> use bksecurity;
Database changed
MariaDB [bksecurity]>
MariaDB [bksecurity]>
MariaDB [bksecurity]> show tables;
Empty set (0.001 sec)