o/s버전
|
1 2 |
[root@localhost ~]# cat /etc/redhat-release Rocky Linux release 8.9 (Green Obsidian) |
repo 파일 생성
|
1 |
[root@localhost ~]# curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-11.3.1" |
설치 진행
|
1 |
[root@localhost ~]# yum install MariaDB-client MariaDB-connect-engine mariadb-devel mariadb-server |
my.cnf 설정 utf8
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
[root@localhost ~]# vi /etc/my.cnf.d/server.cnf [mysqld] character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake #connection max_connections = 1000 max_connect_errors = 1000 wait_timeout= 60 # sqlmode sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
서비스 등록 및 시작
|
1 2 3 4 |
[root@localhost ~]# systemctl enable mariadb Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service. [root@localhost ~]# systemctl start mariadb |
접속확인
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
[root@localhost ~]# mysql mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 11.3.1-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> \s -------------- mysql from 11.3.1-MariaDB, client 15.2 for Linux (x86_64) using readline 5.1 Connection id: 3 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 11.3.1-MariaDB MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb3 Db characterset: utf8mb3 Client characterset: utf8mb3 Conn. characterset: utf8mb3 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 18 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 17 Open tables: 10 Queries per second avg: 0.222 -------------- MariaDB [(none)]> |