Redhat 7 Maria DB installation and configuration

(1) Install Maria DB and create database

yum install -y mariadb*

#Install all related packages of mariadb

systemctl start mariadb

#Start mariadb database

systemctl enable mariadb

#Set mariadb to start automatically when booting by default

mysql

#Enter the database

create database Contacts;

#Create a database named Contacts

show databases;

use Contacts

source /users.mdb

show tables;

grant select on Contacts .* to [email protected]'localhost' identified by 'redhat'; exit

mysqladmin -uroot -p password 'redhat' #two carriage returns

mysql -uroot –p #password input redhat

mysql -uZhangsan –p #password input redhat

(2) Common commands

mysql –uroot –p

show tables;

#View table structure

desc table name;  

#View table fields

select bid,password from pass where password='tangerine'; 

#Check the ID number of the password

select * from name where aid='3';

#Find name by password id