Mariadb Server

 --> To install mariadb-server use following command

# yum install mariadb*

 # systemctl start mariadb

 # mysql

--> to show list of databases

 MariaDB [(none)]> show databases;

--> to create a new database

 MariaDB [(none)]> create database db;

--> here db is the name of database

--> to use the created database

MariaDB [(none)]> use db;

 --> to create table inside the database(db)

MariaDB [(none)]> create table info(name char(20),password char(15));

--> here info is the name of table and name,password are attributes.

 --> to insert values of attributes inside the table info

MariaDB [(none)]> insert into info(name,password)values('sarvesh','redhat');

 MariaDB [(none)]> show tables;

MariaDB [(none)]> desc info;

 --> to see the entire contents of the table

MariaDB [(none)]> select * from info;

 --> to exit out of the database

MariaDB [(none)]> exit

 --> to secure the database with password

[root@mariadb_server ~]# mysql_secure_installation

 
--> set the root password

 --> Now login with the secure password

[root@mariadb_server ~]# mysql -u root -p

 --> In case of forget password

[root@mariadb_server ~]# rm -rf /var/lib/mysql/*

---------------------------------------- #####---------------------------------------------

Some important commands to perform following inside the database

--> To rename Table
  # alter table tablename rename new_tablename ;

--> To add new attribute to the existing table
  # alter table tablename add attribute data_type(size) ;

--> To remove attribute from the existing table
  # alter table tablename drop attribute ;

--> To change size of attribute or type of attribute
  #alter table tablename modify attribute data_type(size) ;

--> Fetching column without repetition of any data
  # select distinct column_name from table_name ;

--> To update the data in particular row
  # update table_name set attribute='xyz' where attribute='zyxa' ;

--> To delete the particular row
 # delete from tablename where attribute='X' ;

--> To delete all rows in which data starting with 'X'
 # delete from tablename where attribute like 'X%' ;


--> To delete all tuples from the table
 #  truncate table table_name ;

--> To delete table schema along with its tuple
 # drop table table_name ;