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
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
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;
centos 7
