CentOS7系统下安装MariaDB，centos7系统mariadb


安装前请替换源为阿里源

安装MariaDB

1.安装命令

yum -y install mariadb mariadb-server

2.安装完成MariaDB，首先启动MariaDB

systemctl start mariadb

3.设置开机启动

systemctl enable mariadb

4.进行MariaDB的相关简单配置

mysql_secure_installation
**1）首先是设置密码，会提示先输入密码**
    Enter current password for root (enter for none):<–初次运行直接回车
    [1]设置密码
        Set root password? [Y/n] <– 是否设置root用户密码，输入y并回车或直接回车
        New password: <– 设置root用户的密码
        Re-enter new password: <– 再输入一次你设置的密码

    [2]其他配置
        Remove anonymous users? [Y/n] <– 是否删除匿名用户，输入y并回车或直接回车
        Disallow root login remotely? [Y/n] <–是否禁止root远程登录,输入n并回车
        Remove test database and access to it? [Y/n] <– 是否删除test数据库，输入y并回车或直接回车
        Reload privilege tables now? [Y/n] <– 是否重新加载权限表，输入y并回车或直接回车

**2）初始化MariaDB完成，接下来测试登录**
    mysql -uroot -p  <- 回车后输入密码

配置MariaDB的字符集

编辑文件/etc/my.cnf

[1]vi /etc/my.cnf
[2]在[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

[1]vi /etc/my.cnf.d/client.cnf
[2]在[client]标签下添加
    default-character-set=utf8

编辑文件/etc/my.cnf.d/mysql-clients.cnf

[1]vi /etc/my.cnf.d/mysql-clients.cnf
[2]在[mysql]标签下添加
    default-character-set=utf8

全部配置完成，重启mariadb

systemctl restart mariadb

进入MariaDB查看字符集

mysql -u root -p
show variables like "%character%";

        +--------------------------+----------------------------+
        | Variable_name            | Value                      |
        +--------------------------+----------------------------+
        | character_set_client     | utf8                       |
        | character_set_connection | utf8                       |
        | character_set_database   | latin1                     |
        | character_set_filesystem | binary                     |
        | character_set_results    | utf8                       |
        | character_set_server     | latin1                     |
        | character_set_system     | utf8                       |
        | character_sets_dir       | /usr/share/mysql/charsets/ |
        +--------------------------+----------------------------+
        8 rows in set (0.01 sec)
show variables like "%collation%";

        +----------------------+-------------------+
        | Variable_name        | Value             |
        +----------------------+-------------------+
        | collation_connection | utf8_general_ci   |
        | collation_database   | latin1_swedish_ci |
        | collation_server     | latin1_swedish_ci |
        +----------------------+-------------------+
        3 rows in set (0.00 sec)

开启远程连接

关闭防火墙或者放行3306端口

关闭防火墙

    systemctl stop firewalld.service
    systemctl disable firewalld.service

放行3306端口（推荐）

    firewall-cmd --zone=public --add-port=3306/tcp --permanent

开启远程连接

开放root用户任意IP远程连接

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION;
    flush privileges;

开放root用户指定IP远程连接（推荐）

        GRANT ALL PRIVILEGES ON *.* TO 'root'@'要指定的IP'IDENTIFIED BY 'root' WITH GRANT OPTION;
        flush privileges;

相关内容