MariaDB install on CENTOS 6.6
Setting up MariaDB Repositories
https://downloads.mariadb.org/mariadb/repositories/#mirror=kaist&distro=CentOS&distro_release=centos6-amd64–centos6&version=10.1
installing MariaDB with yum
https://mariadb.com/kb/en/mariadb/yum/
#/etc/yum.repos.d/MariaDB.repo
Installing MariaDB with YUM
With the repo file in place you can now install MariaDB like so:
#sudo yum install MariaDB-server MariaDB-client
설치중 에러 발생시
In our case I have found all packages related to Mariadb with command
#rpm -qa | grep -i ‘^MariaDB’
And removed them with commands like:
#yum remove MariaDB-server
#yum remove mysql
#yum install MariaDB-server MariaDB-client
#service mysql start
Set MariaDB to start on boot:
# chkconfig mysql on
Secure MariaDB after installation
# mysql_secure_installation — all yes
# service mysql restart
# mysql -u root -p
Installing MariaDB 10.0 with YUM
http://lintut.com/install-mariadb-on-centos/
How to Create a New User
mysql>CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’;
mysql>GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’;
mysql>FLUSH PRIVILEGES;
https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql
1. my.cnf 열어서 포트 변경(보통 /etc/my.cnf에 위치한다)
2. # service mysqld restart
3. iptables에서 자신이 추가한 포트 열기 /etc/sysconfig/iptables 에 아래구문 추가
-A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT
4. iptables 재시작
# service iptables restart
Upgrade MariaDB 10.0.x to MariaDB 10.1.x on Centos (yum)
http://support.qualityunit.com/009608-Upgrade-MariaDB-100x-to-MariaDB-101x-on-Centos-yum