【MariaDB】安装MariaDB 10.2.6

最新推荐文章于 2023-05-06 10:59:03 发布

Mr_EvanChen

最新推荐文章于 2023-05-06 10:59:03 发布

阅读量388

点赞数

分类专栏： Linux 数据库文章标签： Linux MariaDB MySQL

本文链接：https://blog.csdn.net/Mr_EvanChen/article/details/85007346

版权

数据库同时被 2 个专栏收录

29 篇文章 2 订阅

订阅专栏

Linux

22 篇文章 0 订阅

订阅专栏

    mkdir -p /var/log/common/mariadb

    groupadd mysql
    useradd -g mysql mysql

    cd /usr/local/common/mariadb/

    ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/common/mariadb/data

    chown -R root .
    chown -R mysql data
    mkdir /var/lib/mysql
    chown -R mysql /var/lib/mysql
    chown -R mysql /var/log/common/mariadb/
    chown -R mysql /usr/local/common/mariadb/

    /bin/cp -rf ./scripts/my.cnf /etc/
    /bin/cp -rf ./scripts/mysql-clients.cnf /etc/my.cnf.d/
    /bin/cp -rf ./scripts/mariadb_profile.sh        /etc/profile.d/

    # service
    /usr/local/common/mariadb/bin/mysqld_safe --user=mysql --basedir=/usr/local/common/mariadb/

    # 增加密码
    mysqladmin -u root password 'media'

    # 增加远程连接，仅适用于Test环境
    use mysql;
    grant all privileges  on *.* to root@'%' identified by "media";
    flush privileges;

    # 开放防火墙端口，仅适用于Test环境
    firewall-cmd --zone=public --add-port=3306/tcp --permanent
    firewall-cmd --reload

    感谢伟光大佬的辛勤整理！