# yum -y install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm# yum -y install mysql-community-server# systemctl start mysqld# systemctl enable mysqld# mysqlmysql>quit# vi /etc/my.cnf[client] default-character-set = utf8[mysql]default-character-set=utf8[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockcharacter-set-server=utf8collation-server=utf8_general_ciinit_connect=SET collation_connection = utf8_general_ciinit_connect=SET NAMES utf8character-set-client-handshake = FALSEskip-character-set-client-handshake[mysqldump]default-character-set=utf8root 설정 및 보안설정
# /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 |
