Install MariaDB on Linux Centos 7 and Allow remote access

Install MariaDB on Linux CentOS 7 and Allow remote access.

# create Repository
/etc/yum.repos.d/MariaDB.repo

# MariaDB 10.3 CentOS repository list - created 2018-05-25 19:02 UTC
#
[mariadb]
name = MariaDB
baseurl =
gpgkey=
gpgcheck=1


# start install
sudo yum install MariaDB-server MariaDB-client

# start service
sudo systemctl enable mariadb
sudo systemctl start mariadb

# check status
sudo systemctl status mariadb

# run secure
sudo mysql_secure_installation

#connect to database
mysql -u root -p

# show tables
SHOW DATABASES;

# allow firewall
firewall-cmd --zone=public --add-port=55555/tcp --permanent
firewall-cmd --reload

# allow Remote
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
FLUSH PRIVILEGES;
FLUSH HOSTS;

MariaDB Admin Tutorial,MariaDB installation Step by Step,Linux installation of MariaDB,HOW TO INSTALL MARIADB ON CENTOS 7,MariaDB,RemoteAccess,sqlyog,