centos7环境下的mariadb10.4.7 rpm离线安装教程

首先去mariadb官网下载postgresql10.4.7的rpm

https://downloads.mariadb.org/
https://download.csdn.net/download/thedreammaster/11620881

mariadb安装包及依赖包

boost-program-options-1.53.0-27.el7.x86_64.rpm
galera-4-26.4.2-1.rhel7.el7.centos.x86_64.rpm
MariaDB-client-10.4.7-1.el7.centos.x86_64.rpm
MariaDB-common-10.4.7-1.el7.centos.x86_64.rpm
MariaDB-compat-10.4.7-1.el7.centos.x86_64.rpm
MariaDB-server-10.4.7-1.el7.centos.x86_64.rpm
perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm
perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm
perl-Data-Dumper-2.145-3.el7.x86_64.rpm
perl-DBI-1.627-4.el7.x86_64.rpm
perl-IO-Compress-2.061-2.el7.noarch.rpm
perl-Net-Daemon-0.48-5.el7.noarch.rpm
perl-PlRPC-0.2020-14.el7.noarch.rpm

上传包到/tmp

1 yum install boost-program-options-1.53.0-27.el7.x86_64.rpm
2 yum install galera-4-26.4.2-1.rhel7.el7.centos.x86_64.rpm
3 yum install perl*
4 yum install MariaDB*

安装完成后启动数据库

systemctl start mariadb

登录mariadb

mysql -u root -p123456

查看用户账号信息：

select User, host from mysql.user;

开启远程访问权限

root账户中的host项是localhost表示该账号只能进行本地登录，我们需要修改权限，输入命令：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

修改权限。%表示针对所有IP，password表示将用这个密码登录root用户，如果想只让某个IP段的主机连接，可以修改为

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.100.%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;