MariaDB Installation Process and Configuration in RHEL-7
rpm -qa | grep mariadb yum groupinstall mariadb -y firewall-cmd --permanent --add-services=mysql firewall-cmd --reload systemctl start mariadb systemctl enable mariadb systemctl status mariadb mysql_secure_installation Login: ===== mysql -u user_name -p user_password Show Database: ============== show databases; Create Database: ================== create database database_name; select specific database: ========================= use database_name; Create Table: ============= create table table_name ( id varchar(10), name varchar(100), contact varchar(11)); Insert into database: ===================== insert into table_name values ( '01', 'Mushfiq', '01982672499'); Select from table: ================== select * from table_name; Create Use: =========== create user user_name@localhost identified by "User_password"; Give specific permission: ========================= grant select, insert on databa...
