进入下载目录
[root@b ~]# cd /usr/local/src/
下载
[root@b src]# wget https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x86_64/mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz
解压
[root@b src]# tar zxvf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz
移动重命名
[root@b src]# mv mariadb-10.2.6-linux-glibc_214-x86_64 /usr/local/mariadb
初始化
[root@b mariadb]# useradd mysql [root@b mariadb]# mkdir /data/ [root@b mariadb]# pwd /usr/local/mariadb [root@b mariadb]# yum install -y libaio [root@b mariadb]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mariadb
看到OK说明初始化成功
拷贝配置文件
[root@b mariadb]# cp support-files/my-small.cnf /usr/local/mariadb/my.cnf
拷贝启动脚本
[root@b mariadb]# cp support-files/mysql.server /etc/init.d/mariadb
定义basedir和datadir
[root@b mariadb]# vi /usr/local/mariadb/my.cnf [mysqld] port = 3306 datadir= /data/mariadb socket = /tmp/mysql.sock skip-external-locking key_buffer_size = 16K max_allowed_packet = 1M table_open_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 240K
修改启动脚本
[root@b mariadb]# vim /etc/init.d/mariadb basedir=/usr/local/mariadb datadir=/data/mariadb conf=$basedir/my.cnf $bindir/mysqld_safe --defaults-file=$conf --datadir="$datadir" --pid-file="$mysqld_pid_file_path" "$@" & wait_for_ready; return_value=$?
启动服务
[root@b mariadb]# /etc/init.d/mariadb start
Starting mariadb (via systemctl): Warning: mariadb.service changed on disk. Run 'systemctl daemon-reload' to reload units.
[ 确定 ]
[root@b mariadb]# ss -tnlp
State Recv-Q Send-Q Local Address:Port Peer Address:Port
LISTEN 0 128 *:22 *:* users:(("sshd",pid=770,fd=3))
LISTEN 0 100 127.0.0.1:25 *:* users:(("master",pid=1092,fd=13))
LISTEN 0 80 :::3306 :::* users:(("mysqld",pid=2785,fd=21))
LISTEN 0 128 :::22 :::* users:(("sshd",pid=770,fd=4))
LISTEN 0 100 ::1:25 :::* users:(("master",pid=1092,fd=14))
[root@b mariadb]# systemctl daemon-reload
[root@b mariadb]# /etc/init.d/mariadb restart
Restarting mariadb (via systemctl): [ 确定 ]
