【转载】CentOS 7 通过 yum 安装 MariaDB

刺骨的言语ヽ痛彻心扉 2024-02-22 02:02 11阅读 0赞

> 原文章地址：[CentOS 7 通过 yum 安装 MariaDB - 知乎 (zhihu.com)][CentOS 7 _ yum _ MariaDB - _ _zhihu.com]

### 安装步骤： ###

**以下操作都以 root 用户进行操作**

### **安装** ###

安装 mariadb 服务

# yum install -y mariadb-server

安装 mariadb 命令行客户端

# yum install -y mariadb

安装 mariadb C library

# yum install -y mariadb-libs

安装 mariadb 开发包

# yum install -y mariadb-devel

**启动**

启动服务

# systemctl start mariadb

设置服务开启自启动

# systemctl enable mariadb

查看服务状态

# systemctl status mariadb

可能的输出为，注意到 Active 状态为 active (running)

● mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
       Active: active (running) since 五 2018-11-09 12:49:23 CST; 19min ago
     Main PID: 1510 (mysqld_safe)
       CGroup: /system.slice/mariadb.service
               ├─1510 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
               └─2030 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-...
    
    11月 09 12:49:15 peixinchen.host systemd[1]: Starting MariaDB database server...
    11月 09 12:49:17 peixinchen.host mariadb-prepare-db-dir[1062]: Database MariaDB is probably initialized in /var/lib/m...ne.
    11月 09 12:49:19 peixinchen.host mysqld_safe[1510]: 181109 12:49:19 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
    11月 09 12:49:19 peixinchen.host mysqld_safe[1510]: 181109 12:49:19 mysqld_safe Starting mysqld daemon with databas...mysql
    11月 09 12:49:23 peixinchen.host systemd[1]: Started MariaDB database server.
    Hint: Some lines were ellipsized, use -l to show in full.

**测试连接**

使用命令行客户端尝试连接

# mysql -uroot

可能的输出为

Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 2
    Server version: 5.5.60-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)]>

查看 mariadb 版本号

MariaDB [(none)]> select version();
    +----------------+
    | version()      |
    +----------------+
    | 5.5.60-MariaDB |
    +----------------+
    1 row in set (0.01 sec)

创建数据库时为了支持中文，统一使用 utf8mb4 字符集

MariaDB [(none)]> create database demo_db charset utf8mb4;

[CentOS 7 _ yum _ MariaDB - _ _zhihu.com]: https://zhuanlan.zhihu.com/p/49046496