centos7源码安装mariadb10.4.13(脚本)

#!/bin/bash #auto SourceCode Install mariadb #by author toyix #2020年7月2日 13:14:14 yum install -y wget lrzsz vim echo "安装阿里base及epel源" wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo echo "清缓存" yum clean all yum makecache echo "安装软件环境支持" yum install -y wget lrzsz vim boost gcc ncurses-devel libaio bison gcc-c++ git cmake ncurses-devel openssl openssl-devel echo "下载mariadb10.4.16源码包" wget -c https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.4.17/source/mariadb-10.4.17.tar.gz echo "解压" tar -zxvf mariadb-10.4.17.tar.gz cd mariadb-10.4.17/ echo "创建mysql用户" useradd -s /sbin/nologin -r mysql -M echo "预编译" cmake -j4 . \ -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb \ -DMYSQL_DATADIR=/data/mariadb/ \ -DSYSCONFDIR=/usr/local/mariadb \ -DMYSQL_USER=mysql \ -DMYSQL_TCP_PORT=3306 \ -DWITHOUT_TOKUDB=1 \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci echo "编译" make -j4 && make install -j4 echo "查看安装目录" ls /usr/local/mariadb/ echo "配置启动文件及权限等" cd /usr/local/mariadb/ cp support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld mkdir -p /data/mariadb/ chown -R mysql:mysql /data/mariadb chown -R mysql:mysql /usr/local/mariadb/ echo "配置数据库主配置文件" cat >/usr/local/mariadb/my.cnf<<EOF [mysqld] basedir=/usr/local/mariadb/ datadir=/data/mariadb/ port=3306 pid-file=/data/mariadb/mysql.pid socket=/tmp/mysql.sock [mysqld_safe] log-error=/data/mariadb/mysql.log [client] port=3306 socket=/tmp/mysql.sock default-character-set=utf8 EOF echo -e "\033[32m数据库初始化\033[0m" /usr/local/mariadb/scripts/mariadb-install-db --datadir=/data/mariadb/ echo "安装目录改回root权限" chown -R root:root /usr/local/mariadb/ echo "数据目录权限改为mysql" chown -R mysql:mysql /data/mariadb/ ls -l /data/mariadb/ echo "配置环境变量" echo "export PATH=/usr/local/mariadb/bin:$PATH" >/etc/profile.d/mariadb.sh . /etc/profile.d/mariadb.sh echo "启动mysql" /etc/init.d/mysqld restart echo "查看进程" ps -ef|grep mysql netstat -tnlp

执行后结果

You can test the MariaDB daemon with mysql-test-run.pl cd './mysql-test' ; perl mysql-test-run.pl Please report any problems at http://mariadb.org/jira The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/ 安装目录改回root权限 数据目录权限改为mysql total 122924 -rw-rw----. 1 mysql mysql 24576 Jul 2 13:04 aria_log.00000001 -rw-rw----. 1 mysql mysql 52 Jul 2 13:04 aria_log_control -rw-rw----. 1 mysql mysql 972 Jul 2 13:04 ib_buffer_pool -rw-rw----. 1 mysql mysql 12582912 Jul 2 13:04 ibdata1 -rw-rw----. 1 mysql mysql 50331648 Jul 2 13:04 ib_logfile0 -rw-rw----. 1 mysql mysql 50331648 Jul 2 13:04 ib_logfile1 -rw-rw----. 1 mysql mysql 12582912 Jul 2 13:04 ibtmp1 -rw-rw----. 1 mysql mysql 0 Jul 2 13:04 multi-master.info drwx------. 2 mysql mysql 4096 Jul 2 13:04 mysql -rw-rw----. 1 mysql mysql 1864 Jul 2 13:04 mysql.log -rw-rw----. 1 mysql mysql 6 Jul 2 13:04 mysql.pid drwx------. 2 mysql mysql 20 Jul 2 13:04 performance_schema drwx------. 2 mysql mysql 20 Jul 2 13:04 test 配置环境变量 启动mysql Reloading systemd: [ OK ] Restarting mysqld (via systemctl): [ OK ] 查看进程 root 42767 1 3 13:04 ? 00:00:00 /bin/sh /usr/local/mariadb//bin/mysqld_safe --datadir=/data/mariadb/ --pid-file=/data/mariadb/mysql.pid mysql 42876 42767 27 13:04 ? 00:00:00 /usr/local/mariadb/bin/mysqld --basedir=/usr/local/mariadb/ --datadir=/data/mariadb/ --plugin-dir=/usr/local/mariadb//lib/plugin --user=mysql --log-error=/data/mariadb/mysql.log --pid-file=/data/mariadb/mysql.pid --socket=/tmp/mysql.sock --port=3306 root 42911 2197 0 13:04 pts/0 00:00:00 grep mysql Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1816/master tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1551/sshd tcp6 0 0 ::1:25 :::* LISTEN 1816/master tcp6 0 0 :::3306 :::* LISTEN 42876/mysqld tcp6 0 0 :::22 :::* LISTEN 1551/sshd [root@localhost src]#

登录测试

localhost src]# /usr/local/mariadb/bin/mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.4.17-MariaDB Source distribution 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)]>

注：开启root外联

MariaDB [mysql]> grant all privileges on *.* to 'curefun'@'%' identified by '123456'; Query OK, 0 rows affected (0.003 sec) MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.003 sec)

------------------------------------end