Friday, September 11, 2020

Creation of unicadb on mariadb

 [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)


1 comment:

  1. create database unicadb;

    create 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;

    ReplyDelete