Offline installation mariadb

One 、 download Rpm package

Go to MariaDB Official website Select the desired environment rpm Package download address

MariaDB-client-10.4.24-1.el7.centos.x86_64.rpm
MariaDB-compat-10.4.24-1.el7.centos.x86_64.rpm
MariaDB-common-10.4.24-1.el7.centos.x86_64.rpm
MariaDB-server-10.4.24-1.el7.centos.x86_64.rpm
jemalloc-3.6.0-1.el7.x86_64.rpm
jemalloc-devel-3.6.0-1.el7.x86_64.rpm
galera-4-26.4.4-1.rhel7.el7.centos.x86_64.rpm

Upload to centos7 in

Two 、 Install dependencies in order

yum install rsync nmap lsof perl-DBI nc
rpm -ivh jemalloc-3.6.0-1.el7.x86_64.rpm
rpm -ivh jemalloc-devel-3.6.0-1.el7.x86_64.rpm

galera install

yum install boost-devel.x86_64
#  Import signatures and key
rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB

There is no network here , Use other networks to download , Then import

rpm --import RPM-GPG-KEY-MariaDB

rpm -ivh galera-4-26.4.4-1.rhel7.el7.centos.x86_64.rpm

install mariadb relevant

rpm -ivh MariaDB-common-10.4.24-1.el7.centos.x86_64.rpm MariaDB-compat-10.4.24-1.el7.centos.x86_64.rpm MariaDB-client-10.4.24-1.el7.centos.x86_64.rpm MariaDB-server-10.4.24-1.el7.centos.x86_64.rpm

Report errors , Here, due to the previous wrong installation , You can choose to uninstall and reinstall

rpm -qa | grep mariadb-libs
rpm -ev --nodeps  The result of the last command 

Then reinstall galera, Install again mariadb

3、 ... and 、 Security configuration

#  start-up mariadb
service mariadb start
#  After successful startup, run the following command to configure security 
mysql_secure_installation

1. Enter the current password , There is no password after the initial installation , Directly enter
2. Ask if you want to use unix_socket Authentication ：n
3. by root Set the password ：y
4. Input root New password for ：root
5. Confirm input root New password for ：root
6. Remove anonymous users , This is casual , It is suggested to delete ：y
7. Deny user remote login , This suggestion turns on ：n
8. Delete test library , You can keep ：n
9. Reload permission table ：y

Four 、 Configure permissions

#  Sign in mysql
mysql -u root -p
#  To configure root jurisdiction , Allow any host to connect to mysql
grant all privileges on *.* to [email protected]'%' identified by '111111';
#  Refresh the permissions 
flush privileges;

5、 ... and 、 adopt navicat test