OS/CentOS72017. 6. 23. 10:10
# yum -y install mysql-community-server
# systemctl start mysqld
# systemctl enable mysqld
# mysql
mysql>quit


# 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


root 설정 및 보안설정

# /usr/bin/mysql_secure_installation


포트 허용

# firewall-cmd --permanent --zone=public --add-port=3306/tcp
# firewall-cmd --reload

'OS > CentOS7' 카테고리의 다른 글

centos7 + apache +tomcat 연동  (0) 2019.01.10
CentOS7 Vnc 설정관련  (0) 2017.06.22
CentOS7 Locale설정  (0) 2017.06.22
Posted by idwook