# 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
# 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 |