CloudVM 之 MariaDB install

一时失言乱红尘 2022-04-25 00:22 144阅读 0赞

## 前言 ##

本小节我们学习一下在CoentOS下安装MariaDB。

## 案例 ##

[root@test-vm03 ~]# yum -y install mariadb mariadb-server
    [root@test-vm03 ~]# systemctl start mariadb
    [root@test-vm03 ~]# systemctl enable mariadb
      
    接下来进行MariaDB的相关简单配置，设置密码，会提示先输入密码
    [root@test-vm03 ~]# mysql_secure_installation
    首先是设置密码，会提示先输入密码
      
    Enter current password for root (enter for none):<–初次运行直接回车
      
    设置密码
      
    Set root password? [Y/n] <– 是否设置root用户密码，输入y并回车或直接回车
    New password: <– 设置root用户的密码
    Re-enter new password: <– 再输入一次你设置的密码
      
    其他配置
    Remove anonymous users? [Y/n] <– 是否删除匿名用户，回车
    Disallow root login remotely? [Y/n] <–是否禁止root远程登录,回车,
    Remove test database and access to it? [Y/n] <– 是否删除test数据库，回车
    Reload privilege tables now? [Y/n] <– 是否重新加载权限表，回车
     
    [root@test-vm03 ~]# mysql -p123456
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 3
    Server version: 5.5.56-MariaDB MariaDB Server
     
    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
     
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
     
    MariaDB [(none)]> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    +--------------------+
    4 rows in set (0.01 sec)
     
    MariaDB [(none)]>
     
     
    接下来配置MariaDB的字符集:
    -> 首先是配置文件/etc/my.cnf，在[mysqld]标签下添加
    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
      
    -> 接着配置文件/etc/my.cnf.d/client.cnf，在[client]中添加
    default-character-set=utf8
      
    -> 然后配置文件/etc/my.cnf.d/mysql-clients.cnf，在[mysql]中添加
    default-character-set=utf8
      
    最后是重启MariaDB，并登陆MariaDB查看字符集
    [root@test-vm001 my.cnf.d]# systemctl restart mariadb
     
    [root@test-vm03 ~]# mysql -p123456
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 4
    Server version: 5.5.56-MariaDB MariaDB Server
     
    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
     
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
     
    MariaDB [(none)]> show variables like "%character%";show variables like "%collation%";
    +--------------------------+----------------------------+
    | 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/ |
    +--------------------------+----------------------------+
    8 rows in set (0.00 sec)
     
    +----------------------+-----------------+
    | Variable_name        | Value           |
    +----------------------+-----------------+
    | collation_connection | utf8_unicode_ci |
    | collation_database   | utf8_unicode_ci |
    | collation_server     | utf8_unicode_ci |
    +----------------------+-----------------+
    3 rows in set (0.00 sec)
     
    MariaDB [(none)]>

# 小结 #

*  删除MariaDB
    
        [root@localhost~]# rpm -aq|grep mariadb  
        mariadb-libs-5.5.50-1.e17_2.x86_64  
        mariadb-5.5.50-1.e17_2.x86_64  
        mariadb-server-5.5.50-1.e17_2.x86_64  
        [root@localhost~]# yum -y remove mariadb*