Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you how to binary installation mariadb database version 10.5.3, I believe most people still do not know how to share this article for your reference, I hope you read this article after a great harvest, let us go to understand it!

binary install mariadb database version 10.5.3

Since mariadb version 10.5.3 was released on May 12, 2020, in order to taste it, today I specially compiled the #binary into the/usr/local/src directory, and then downloaded the mariadb database version 10.5.3 on Tsinghua source.

[22:29:34 root@a7 ~]#wget https://mirrors.tuna.tsinghua.edu.cn/mariadb/mariadb-10.5.3/bintar-linux-systemd-x86_64/mariadb-10.5.3-linux-systemd-x86_64.tar.gz

#Creating MySQL Users

[22:32:59 root@a7 ~]#useradd mysql -s /sbin/nologin -M

#Create custom database directories

[22:33:15 root@a7 ~]#mkdir /data/mysql/mysql3306/{data,binlog,logs,tmp} -p

#Authorize mysql3306 directory to mysql users

[22:49:32 root@a7 ~]#cd /data/mysql/;chown -R mysql.mysql mysql3306

#Install dependent packages

22:49:33 root@a7 mysql]#yum install libaio.x86_64 libaio-devel.x86_64 novacom-server.x86_64 libedit -y

#Go back to root directory, extract installation package, specify extract to/usr/local

[22:50:11 root@a7 mysql]#cd[18:04:45 root@a7 ~]#tar xf mariadb-10.5.3-linux-systemd-x86_64.tar.gz -C /usr/local/

#Go to/usr/local/src and add a mysql soft link

[17:13:49 root@a7 ~]#cd /usr/local/[17:21:14 root@a7 local]#ln -s mariadb-10.5.3-linux-systemd-x86_64 mysql

#Tip: Create an empty shadow file.my.cnf in/usr/local/mysql/directory during initialization, otherwise it will prompt that the file does not exist, resulting in initialization failure.

[17:21:14 root@a7 local]#cd /usr/local/mysql/;touch .my.cnf

#Initialize command

[17:25:50 root@a7 mysql]#./ scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/mysql3306/data --defaults-file=./. my.cnf

#Modify the/etc/my.cnf configuration file and specify the database storage directory.

[22:36:11 root@a7 mysql]#vim /etc/my.cnf[mysqld]

datadir=/data/mysql/mysql3306/data #Specify the database storage directory socket=/tmp/mysql.sock #Specify the boot sock file

# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid## include all files from the config directory#! includedir /etc/my.cnf.d

#Configure mariadb startup mode after initialization

[22:23:08 root@a7 mysql]#cp support-files/systemd/mariadb.service /usr/lib/systemd/system/mariadb.service

#Start mariadb service

[22:59:25 root@a7 mysql]#systemctl start mariadb

#Then in view of port, 3306 already up

[22:59:28 root@a7 mysql]#ss -ntlState Recv-Q Send-Q Local Address:Port Peer Address:Port LISTEN 0 128 *:111 *:* LISTEN 0 5 192.168.122.1:53 *:* LISTEN 0 128 *:22 *:* LISTEN 0 128 127.0.0.1:631 *:* LISTEN 0 100 127.0.0.1:25 *:* LISTEN 0 128 127.0.0.1:6010 *:* LISTEN 0 128 127.0.0.1:6011 *:* LISTEN 0 80 :::3306 :::*

#Do soft connection, enter interactive mode through mysql command

[23:15:57 root@a7 mysql]#ln -s /usr/local/mysql/bin/mysql /usr/bin/[23:16:07 root@a7 mysql]#mysqlWelcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 5Server version: 10.5.3-MariaDB MariaDB ServerCopyright (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)]> The above is "How to install mariadb database version 10.5.3 binary" All the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.