maria DB 10 설치 (text)

설치 버전 : 

db: mariadb-10.0.14

os : redhat : Red Hat Enterprise Linux Server release 5.9 (Tikanga)

설치 방법 : cmake 를 이용한 설치 

[root@ogg1 bin]# tar xvfzp mariadb-10.1.21.tar.gz ## 압축풀기

cmake . -DCMAKE_INSTALL_PREFIX=/maria \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DWITH_SSL:STRING=bundled \

-DWITH_ZLIB:STRING=bundled \

-DWITH_LIBWRAP=0 \

-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

# 컴파일

make

# 설치

make install

[root@ogg1 maria]# groupadd mysql     # 그룹생성 

[root@ogg1 maria]# useradd -g mysql mysql  #  # 유저 생성

[root@ogg1 maria]# chown -R mysql:mysql /maria

[root@ogg1 maria]# cp support-files/mysql.server /etc/rc.d/init.d/mysqld  ### 서비스 등록 )

[root@ogg1 maria]# chmod 755 /etc/rc.d/init.d/mysqld                           

[root@ogg1 maria]# chkconfig --add mysqld

[root@ogg1 maria]# chkconfig --list | grep mysql

          mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off

[root@ogg1 maria]# ./scripts/mysql_install_db --user=mysql --basedir=/maria --datadir=/maria/data   #기본 데이터 생성

[root@ogg1 maria]#  /maria/bin/mysqladmin -u root password 'maria'  # root 패스워드 설정 

[root@ogg1 bin]# ./mysql -uroot -p  ### 접속 테스트 

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 3

Server version: 10.1.21-MariaDB Source distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

MariaDB [(none)]>

MariaDB [(none)]>

MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test               |

+--------------------+

4 rows in set (0.00 sec)