云服务器centos7离线安装MariaDB

云服务器centos7离线安装MariaDB

一、详细可参考官网离线安装教程

https://mariadb.com/kb/en/mariadb-installation-version-10121-via-rpms-on-centos-7/
官网给的资料较老，可以根据自己需要的版本更换相关参数

二、缺少依赖

按照官网的操作还缺少libaio的依赖

error: Failed dependencies:
        libaio.so.1()(64bit) is needed by MariaDB-client-10.4.8-1.el7.centos.x86_64
        libaio.so.1(LIBAIO_0.1)(64bit) is needed by MariaDB-client-10.4.8-1.el7.centos.x86_64
        libaio.so.1(LIBAIO_0.4)(64bit) is needed by MariaDB-client-10.4.8-1.el7.centos.x86_64
        libaio.so.1()(64bit) is needed by MariaDB-server-10.4.8-1.el7.centos.x86_64
        libaio.so.1(LIBAIO_0.1)(64bit) is needed by MariaDB-server-10.4.8-1.el7.centos.x86_64
        libaio.so.1(LIBAIO_0.4)(64bit) is needed by MariaDB-server-10.4.8-1.el7.centos.x86_64

下载libaio依赖，有些版本链接可能已经找不到，可以更换能用的版本。

wget http://mirror.centos.org/centos/7/os/x86_64/Packages/libaio-0.3.109-13.el7.x86_64.rpm

安装相应依赖包

rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm

再次安装，成功

rpm -ivh MariaDB-common-10.4.8-1.el7.centos.x86_64.rpm MariaDB-compat-10.4.8-1.el7.centos.x86_64.rpm MariaDB-client-10.4.8-1.el7.centos.x86_64.rpm galera-4-26.4.2-1.rhel7.el7.centos.x86_64.rpm MariaDB-server-10.4.8-1.el7.centos.x86_64.rpm

三、配置数据库相关信息

# 启动mariaDB,(因为mariaDB是mysql作者写的新的数据库，其实服务和mysql是一样的，所以启动使用的是下面)
[root@iZ2ze7s2v0b78922wia32rZ ~]# service mysql start
# 安全配置
[root@iZ2ze7s2v0b78922wia32rZ ~]# mysql_secure_installation
# 输入root密码，安装后第一次启动为空，直接回车
Enter current password for root (enter for none): 
# step 1： 是否切换到unix_socket安全认证，否
Switch to unix_socket authentication [Y/n] n
# step 2: 更改密码，选择修改
Change the root password? [Y/n] y
# step 3: 移除匿名用户，选择是
Remove anonymous users? [Y/n] y
# step 4: 是否允许root远程登录，根据个人需求，因为我是测试服务器选择允许
Disallow root login remotely? [Y/n] y
# step 5: 移除test数据库
Remove test database and access to it? [Y/n] y
# step 6: 重新加载权限表
Reload privilege tables now? [Y/n] y
# 看到下面，说明成功啦！！！
All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!

四、测试

登录数据库

mysql -u root -p

修改权限

grant all privileges on *.* to 'root'@'%' identified by 'your password';

刷新

flush privileges;

工具测试

参考文献：https://www.jianshu.com/p/a7d201c212c5