Difference between revisions of "MariaDB"
From AlphaBook
(Created page with "== Install == * yum install mariadb-server -y * mysql_secure_installation == Configure Service == * systemctl start mariadb * systemctl enable mariadb * systemctl status mari...") |
(→Configure Firewall (TCP 3306)) |
||
Line 9: | Line 9: | ||
== Configure Firewall (TCP 3306) == | == Configure Firewall (TCP 3306) == | ||
− | * firewall-cmd --add-service mysql | + | * firewall-cmd --permanent --add-service mysql |
* firewall-cmd --list-service | * firewall-cmd --list-service | ||
Revision as of 03:00, 28 December 2018
Contents
Install
- yum install mariadb-server -y
- mysql_secure_installation
Configure Service
- systemctl start mariadb
- systemctl enable mariadb
- systemctl status mariadb
Configure Firewall (TCP 3306)
- firewall-cmd --permanent --add-service mysql
- firewall-cmd --list-service
Database Operation
- mysql -u root -p
- show databases;
- create database Test;
- drop database Test;
- create database myDB;
- grant all privileges on myDB.* to myDBower@'%' identified by '123.com';
- grant select on myDB.* to myDBread@'%' identified by '123.com';
- flush privileges;
Backup and Restore
- mysqldump -uroot -p123.com myDB | gzip >> /backup/myDB.sql.gz
- gunzip /backup/myDB.sql.gz
- cat /backup/myDB.sql | mysql -uroot -p123.com myDB