mariadb 설치

마리아DB(mariadb) 설치 

centos7 기준으로 설명함.(단, centos배포판에는 기본적으로 설치되어 있음)

1. 설치
# yum install -y mariadb-server
# systemctl enable mariadb
# systemctl start mariadb


2. root 패스워드
# mysqladmin -u root password ****

 

3. 사용자
mysql root 접속
> create user '사용자ID'@'%' identified by '비번'; <--- 원격접속
> GRANT ALL PRIVILEGES ON 데이터베이스.* TO '사용자ID'@'%';
> flush privileges;

4 비번변경
> set password for 사용자ID=password('비번');


5. 문자셋 변경 : utf-8
 /etc/my.cnf.d/client.cnf
[client]
default-character-set=utf8

• /etc/my.cnf.d/mysql-clients.cnf
[mysql]
default-character-set=utf8

[mysqldump]
default-character-set=utf8

• /etc/my.cnf.d/server.cnf
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

6. 재시작
sudo systemctl restart mariadb --> MariaDB 재시작

 

7. 확인
MariaDB [(none)]> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
| collation_connection     | utf8_general_ci            |
| collation_database       | utf8_unicode_ci            |
| collation_server         | utf8_unicode_ci            |
| completion_type          | NO_CHAIN                   |
| concurrent_insert        | AUTO                       |
| connect_timeout          | 10                         |
+--------------------------+----------------------------+
14 rows in set (0.00 sec)