[root@database bin]# ./mysql -h localhost -u root -pP@ssw0rd
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.5.5-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)]> create database unicadb;
Query OK, 1 row affected (0.011 sec)
MariaDB [(none)]> create user platuser identified by 'P@ssw0rd';
Query OK, 0 rows affected (0.025 sec)
MariaDB [(none)]> grant all privileges on unicadb.* to platuser;
Query OK, 0 rows affected (0.004 sec)
MariaDB [(none)]> create user campuser identified by 'P@ssw0rd';
Query OK, 0 rows affected (0.002 sec)
MariaDB [(none)]> create user mouser identified by 'P@ssw0rd';
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> create user intuser identified by 'P@ssw0rd';
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> create user lrnuser identified by 'P@ssw0rd';
Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> create user platweb identified by 'P@ssw0rd';
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> create user platcallcntr identified by 'P@ssw0rd';
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> grant all privileges on unicadb.* to campuser;
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> grant all privileges on unicadb.* to mouser;
Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> grant all privileges on unicadb.* to intuser;
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> grant all privileges on unicadb.* to lrnuser;
Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> grant all privileges on unicadb.* to platweb;
Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> grant all privileges on unicadb.* to platcallcntr;
Query OK, 0 rows affected (0.000 sec)
create database unicadb;
ReplyDeletecreate user up identified by 'password123';
create user ump identified by 'password123';
create user uc identified by 'password123';
create user uirt identified by 'password123';
grant all privileges on unicadb.* to up;
grant all privileges on unicadb.* to ump;
grant all privileges on unicadb.* to uc;
grant all privileges on unicadb.* to uirt;