CentOS 7 에 mysql 설치하고 설정까지

설치

# yum -y install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

   (오류시 dhclient)

# yum -y install mysql-community-server

# systemctl start mysqld

# systemctl enable mysqld

접속 확인

# mysql

mysql > quit

characterset 값 변경 (-> utf8)

# vi /etc/my.cnf

[client] 

default-character-set = utf8

 

[mysql]

default-character-set=utf8

 

[mysqld]

 

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

 

character-set-server=utf8

collation-server=utf8_general_ci

init_connect=SET collation_connection = utf8_general_ci

init_connect=SET NAMES utf8

 

character-set-client-handshake = FALSE

skip-character-set-client-handshake

 

[mysqldump]

default-character-set=utf8

# systemstl restart mysqld

확인

# mysql

mysql > status

root 패스워드 변경

mysql > use mysql

mysql > update user set password=password('[PASSWORD]') where user = 'root';

mysql > flush privileges;

mysql > quit

외부 접근 허용

(iptables 에 3306 포트 추가)

# vi /etc/sysconfig/iptables

...

:INPUT ACCEPT [0:0]

:FORWARD ACCEPT [0:0]

:OUTPUT ACCEPT [0:0]

-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT

-A INPUT -p icmp -j ACCEPT

-A INPUT -i lo -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

-A INPUT -j REJECT --reject-with icmp-host-prohibited

-A FORWARD -j REJECT --reject-with icmp-host-prohibited

COMMIT

...

# systemctl restart iptables

# mysql

mysql > use mysql

mysql > select host, user, password from user;

(데이터베이스 만들 경우)

mysql > create database [DB NAME] default character set utf8;

(계정 만들 경우)

mysql > create user [ID]@'%' identified by [PASSWORD];

mysql > create user [ID]@'localhost' identified by [PASSWORD];

(계정 확인)

mysql > select host, user, password from user;

(모든 권한 추가)

mysql > grant all privileges on *.* to [ID]@'%';

(특정 DB 접근 권한 추가)

mysql > grant all privileges on [DB NAME].* to [ID]@'%';