Install MariaDB on CentOS 7

* mariadb install
– yum install mariadb
– yum install mariadb-server

* service regist
– chkconfig mariadb on

* Securing MariaDB
– /usr/bin/mysql_secure_installation
Remove anonymous users? Y
Disallow root login remotely? Y
Remove test database and access to it? Y
Reload Privileage tables now? Y

iptables에서 3306 열어주고 외부에서 접속시….
Host ‘xxx.xxx.xxx.xxx’ is not allowed to connect to this MariaDB server

mysql – uroot -p
MariaDB>use mysql
MariaDB [mysql]> grant all privileges on *.* to ‘mariadb루트계정’@’%’ identified by ‘비밀번호’;

외부에서 해당 계정에 대해 접근허용

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.