* mariadb install
\n– yum install mariadb
\n– yum install mariadb-server<\/p>\n
* service regist
\n– chkconfig mariadb on<\/p>\n
* Securing MariaDB
\n– \/usr\/bin\/mysql_secure_installation
\nRemove anonymous users? Y
\nDisallow root login remotely? Y
\nRemove test database and access to it? Y
\nReload Privileage tables now? Y<\/p>\n
iptables\uc5d0\uc11c 3306 \uc5f4\uc5b4\uc8fc\uace0 \uc678\ubd80\uc5d0\uc11c \uc811\uc18d\uc2dc….
\nHost ‘xxx.xxx.xxx.xxx’ is not allowed to connect to this MariaDB server<\/p>\n
mysql – uroot -p
\nMariaDB>use mysql
\nMariaDB [mysql]> grant all privileges on *.* to ‘mariadb\ub8e8\ud2b8\uacc4\uc815’@’%’ identified by ‘\ube44\ubc00\ubc88\ud638’;<\/p>\n
\uc678\ubd80\uc5d0\uc11c \ud574\ub2f9 \uacc4\uc815\uc5d0 \ub300\ud574 \uc811\uadfc\ud5c8\uc6a9<\/p>\n","protected":false},"excerpt":{"rendered":"
* 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\uc5d0\uc11c 3306 \uc5f4\uc5b4\uc8fc\uace0 \uc678\ubd80\uc5d0\uc11c \uc811\uc18d\uc2dc…. Host ‘xxx.xxx.xxx.xxx’ is not allowed … Continue reading Install MariaDB on CentOS 7<\/span>