Linux系统之安装mariadb方法,
Linux系统之安装mariadb方法
- 一、检查系统版本
- 二、配置mariadb的yum源
- 1.配置yum源
- 2.替换中科大的源
- 三、检查yum仓库
- 1.修改/etc/yum.conf文件
- 2.检查yum仓库
- 四、安装mariadb
- 五、启动mariadb服务
- 1.启动mariadb服务
- 2.查看mariadb服务状态
- 六、mariadb的远程连接
- 1.本地连接
- 2.创建用户
- 3.对用户授权
- 4.测试远程连接mariadb数据库
一、检查系统版本
[root@serer01 ~]# cat /etc/os-release NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL="https://www.centos.org/" BUG_REPORT_URL="https://bugs.centos.org/" CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7"
二、配置mariadb的yum源
1.配置yum源
[root@serer01 ~]# cat /etc/yum.repos.d/mariadb.repo # MariaDB 10.6 CentOS repository list - created 2021-12-27 11:21 UTC # https://mariadb.org/download/ [mariadb] name = MariaDB baseurl = https://mirrors.xtom.com.hk/mariadb/yum/10.6/centos7-amd64 gpgkey=https://mirrors.xtom.com.hk/mariadb/yum/RPM-GPG-KEY-MariaDB gpgcheck=0 enable=1
2.替换中科大的源
sed -i 's#//mirrors.xtom.com.hk#//mirrors.ustc.edu.cn#g' /etc/yum.repos.d/mariadb.repo
三、检查yum仓库
1.修改/etc/yum.conf文件
[root@serer01 ~]# grep false /etc/yum.conf sslverify=false
2.检查yum仓库
[root@serer01 ~]# yum repolist all |grep enable base/7/x86_64 CentOS-7 - Base - mirrors.a enabled: 10,072 docker-ce-stable/7/x86_64 Docker CE Stable - x86_64 enabled: 183 extras/7/x86_64 CentOS-7 - Extras - mirrors enabled: 515 mariadb MariaDB enabled: 95 updates/7/x86_64 CentOS-7 - Updates - mirror enabled: 4,346
四、安装mariadb
[root@serer01 ~]# yum -y install Mariadb-server Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirrors.aliyun.com * extras: mirrors.aliyun.com * updates: mirrors.aliyun.com No package Mariadb-server available. * Maybe you meant: MariaDB-server, mariadb-server Error: Nothing to do [root@serer01 ~]# yum -y install Mariadb-server --nodeps Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirrors.aliyun.com * extras: mirrors.aliyun.com * updates: mirrors.aliyun.com No package Mariadb-server available. * Maybe you meant: MariaDB-server, mariadb-server Error: Nothing to do [root@serer01 ~]# yum -y install MariaDB-server Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirrors.aliyun.com * extras: mirrors.aliyun.com * updates: mirrors.aliyun.com Resolving Dependencies --> Running transaction check ---> Package MariaDB-server.x86_64 0:10.6.10-1.el7.centos will be installed --> Processing Dependency: MariaDB-common >= 10.6.1 for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: MariaDB-client >= 10.6.1 for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: libpmem.so.1(LIBPMEM_1.0)(64bit) for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: rsync for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: galera-4 for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: libcrypto.so.10(OPENSSL_1.0.2)(64bit) for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: lsof for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: libpmem.so.1()(64bit) for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: libpcre2-8.so.0()(64bit) for package: MariaDB-server-10.6.10-1.el7.centos.x86_64 --> Running transaction check ---> Package MariaDB-client.x86_64 0:10.6.10-1.el7.centos will be installed --> Processing Dependency: perl(DBI) for package: MariaDB-client-10.6.10-1.el7.centos.x86_64 --> Processing Dependency: perl(Data::Dumper) for package: MariaDB-client-10.6.10-1.el7.centos.x86_64 ---> Package MariaDB-common.x86_64 0:10.6.10-1.el7.centos will be installed --> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.6.10-1.el7.centos.x86_64 ---> Package galera-4.x86_64 0:26.4.12-1.el7.centos will be installed --> Processing Dependency: socat for package: galera-4-26.4.12-1.el7.centos.x86_64 --> Processing Dependency: libboost_program_options-mt.so.1.53.0()(64bit) for package: galera-4-26.4.12-1.el7.centos.x86_64 ---> Package libpmem.x86_64 0:1.5.1-2.1.el7 will be installed ---> Package lsof.x86_64 0:4.87-6.el7 will be installed ---> Package openssl-libs.x86_64 1:1.0.1e-42.el7.9 will be updated --> Processing Dependency: openssl-libs(x86-64) = 1:1.0.1e-42.el7.9 for package: 1:openssl-1.0.1e-42.el7.9.x86_64 ---> Package openssl-libs.x86_64 1:1.0.2k-25.el7_9 will be an update ---> Package pcre2.x86_64 0:10.23-2.el7 will be installed ---> Package rsync.x86_64 0:3.1.2-11.el7_9 will be installed --> Running transaction check ---> Package MariaDB-compat.x86_64 0:10.6.10-1.el7.centos will be obsoleting ---> Package boost-program-options.x86_64 0:1.53.0-28.el7 will be installed ---> Package mariadb-libs.x86_64 1:5.5.44-2.el7.centos will be obsoleted ---> Package openssl.x86_64 1:1.0.1e-42.el7.9 will be updated ---> Package openssl.x86_64 1:1.0.2k-25.el7_9 will be an update ---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed --> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64 --> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64 ---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed ---> Package socat.x86_64 0:1.7.3.2-2.el7 will be installed --> Running transaction check ---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed --> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch --> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch --> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch --> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch --> Running transaction check ---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed --> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch --> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch ---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed --> Running transaction check ---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed ---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved =================================================================================================================================================== Package Arch Version Repository Size =================================================================================================================================================== Installing: MariaDB-compat x86_64 10.6.10-1.el7.centos mariadb 2.2 M replacing mariadb-libs.x86_64 1:5.5.44-2.el7.centos MariaDB-server x86_64 10.6.10-1.el7.centos mariadb 25 M Installing for dependencies: MariaDB-client x86_64 10.6.10-1.el7.centos mariadb 14 M MariaDB-common x86_64 10.6.10-1.el7.centos mariadb 81 k boost-program-options x86_64 1.53.0-28.el7 base 156 k galera-4 x86_64 26.4.12-1.el7.centos mariadb 9.9 M libpmem x86_64 1.5.1-2.1.el7 base 59 k lsof x86_64 4.87-6.el7 base 331 k pcre2 x86_64 10.23-2.el7 base 201 k perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k perl-DBI x86_64 1.627-4.el7 base 802 k perl-Data-Dumper x86_64 2.145-3.el7 base 47 k perl-IO-Compress noarch 2.061-2.el7 base 260 k perl-Net-Daemon noarch 0.48-5.el7 base 51 k perl-PlRPC noarch 0.2020-14.el7 base 36 k rsync x86_64 3.1.2-11.el7_9 updates 408 k socat x86_64 1.7.3.2-2.el7 base 290 k Updating for dependencies: openssl x86_64 1:1.0.2k-25.el7_9 updates 494 k openssl-libs x86_64 1:1.0.2k-25.el7_9 updates 1.2 M Transaction Summary =================================================================================================================================================== Install 2 Packages (+16 Dependent packages) Upgrade ( 2 Dependent packages) Total download size: 56 M Downloading packages: Delta RPMs disabled because /usr/bin/applydeltarpm not installed. (1/20): MariaDB-common-10.6.10-1.el7.centos.x86_64.rpm | 81 kB 00:00:00 (2/20): MariaDB-compat-10.6.10-1.el7.centos.x86_64.rpm | 2.2 MB 00:00:00 (3/20): MariaDB-client-10.6.10-1.el7.centos.x86_64.rpm | 14 MB 00:00:01 (4/20): boost-program-options-1.53.0-28.el7.x86_64.rpm | 156 kB 00:00:00 (5/20): libpmem-1.5.1-2.1.el7.x86_64.rpm | 59 kB 00:00:00 (6/20): openssl-1.0.2k-25.el7_9.x86_64.rpm | 494 kB 00:00:00 (7/20): pcre2-10.23-2.el7.x86_64.rpm | 201 kB 00:00:00 (8/20): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00 (9/20): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00 (10/20): openssl-libs-1.0.2k-25.el7_9.x86_64.rpm | 1.2 MB 00:00:00 (11/20): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00 (12/20): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00 (13/20): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00 (14/20): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00 (15/20): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 (16/20): socat-1.7.3.2-2.el7.x86_64.rpm | 290 kB 00:00:00 (17/20): lsof-4.87-6.el7.x86_64.rpm | 331 kB 00:00:00 (18/20): rsync-3.1.2-11.el7_9.x86_64.rpm | 408 kB 00:00:00 (19/20): MariaDB-server-10.6.10-1.el7.centos.x86_64.rpm | 25 MB 00:00:02 (20/20): galera-4-26.4.12-1.el7.centos.x86_64.rpm | 9.9 MB 00:00:01 --------------------------------------------------------------------------------------------------------------------------------------------------- Total 19 MB/s | 56 MB 00:00:02 Running transaction check Running transaction test Transaction test succeeded Running transaction Updating : 1:openssl-libs-1.0.2k-25.el7_9.x86_64 1/23 Installing : pcre2-10.23-2.el7.x86_64 2/23 Installing : libpmem-1.5.1-2.1.el7.x86_64 3/23 Installing : perl-Data-Dumper-2.145-3.el7.x86_64 4/23 Installing : rsync-3.1.2-11.el7_9.x86_64 5/23 Installing : lsof-4.87-6.el7.x86_64 6/23 Updating : 1:openssl-1.0.2k-25.el7_9.x86_64 7/23 Installing : MariaDB-common-10.6.10-1.el7.centos.x86_64 8/23 Installing : MariaDB-compat-10.6.10-1.el7.centos.x86_64 9/23 Installing : socat-1.7.3.2-2.el7.x86_64 10/23 Installing : perl-Net-Daemon-0.48-5.el7.noarch 11/23 Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 12/23 Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 13/23 Installing : perl-IO-Compress-2.061-2.el7.noarch 14/23 Installing : perl-PlRPC-0.2020-14.el7.noarch 15/23 Installing : perl-DBI-1.627-4.el7.x86_64 16/23 Installing : MariaDB-client-10.6.10-1.el7.centos.x86_64 17/23 Installing : boost-program-options-1.53.0-28.el7.x86_64 18/23 Installing : galera-4-26.4.12-1.el7.centos.x86_64 19/23 Installing : MariaDB-server-10.6.10-1.el7.centos.x86_64 20/23 Two all-privilege accounts were created. One is root@localhost, it has no password, but you need to be system 'root' user to connect. Use, for example, sudo mysql The second is mysql@localhost, it has no password either, but you need to be the system 'mysql' user to connect. After connecting you can set the password, if you would need to be able to connect as any of these users with a password and without sudo See the MariaDB Knowledgebase at https://mariadb.com/kb Please report any problems at https://mariadb.org/jira The latest information about MariaDB is available at https://mariadb.org/. Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/ Erasing : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 21/23 Cleanup : 1:openssl-1.0.1e-42.el7.9.x86_64 22/23 Cleanup : 1:openssl-libs-1.0.1e-42.el7.9.x86_64 23/23 Verifying : boost-program-options-1.53.0-28.el7.x86_64 1/23 Verifying : 1:openssl-1.0.2k-25.el7_9.x86_64 2/23 Verifying : lsof-4.87-6.el7.x86_64 3/23 Verifying : MariaDB-server-10.6.10-1.el7.centos.x86_64 4/23 Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 5/23 Verifying : rsync-3.1.2-11.el7_9.x86_64 6/23 Verifying : MariaDB-compat-10.6.10-1.el7.centos.x86_64 7/23 Verifying : MariaDB-client-10.6.10-1.el7.centos.x86_64 8/23 Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 9/23 Verifying : perl-DBI-1.627-4.el7.x86_64 10/23 Verifying : libpmem-1.5.1-2.1.el7.x86_64 11/23 Verifying : pcre2-10.23-2.el7.x86_64 12/23 Verifying : galera-4-26.4.12-1.el7.centos.x86_64 13/23 Verifying : 1:openssl-libs-1.0.2k-25.el7_9.x86_64 14/23 Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 15/23 Verifying : perl-Net-Daemon-0.48-5.el7.noarch 16/23 Verifying : perl-IO-Compress-2.061-2.el7.noarch 17/23 Verifying : perl-PlRPC-0.2020-14.el7.noarch 18/23 Verifying : MariaDB-common-10.6.10-1.el7.centos.x86_64 19/23 Verifying : socat-1.7.3.2-2.el7.x86_64 20/23 Verifying : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 21/23 Verifying : 1:openssl-libs-1.0.1e-42.el7.9.x86_64 22/23 Verifying : 1:openssl-1.0.1e-42.el7.9.x86_64 23/23 Installed: MariaDB-compat.x86_64 0:10.6.10-1.el7.centos MariaDB-server.x86_64 0:10.6.10-1.el7.centos Dependency Installed: MariaDB-client.x86_64 0:10.6.10-1.el7.centos MariaDB-common.x86_64 0:10.6.10-1.el7.centos boost-program-options.x86_64 0:1.53.0-28.el7 galera-4.x86_64 0:26.4.12-1.el7.centos libpmem.x86_64 0:1.5.1-2.1.el7 lsof.x86_64 0:4.87-6.el7 pcre2.x86_64 0:10.23-2.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 rsync.x86_64 0:3.1.2-11.el7_9 socat.x86_64 0:1.7.3.2-2.el7 Dependency Updated: openssl.x86_64 1:1.0.2k-25.el7_9 openssl-libs.x86_64 1:1.0.2k-25.el7_9 Replaced: mariadb-libs.x86_64 1:5.5.44-2.el7.centos Complete!
五、启动mariadb服务
1.启动mariadb服务
[root@serer01 ~]# systemctl enable --now mariadb Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
2.查看mariadb服务状态
[root@serer01 ~]# systemctl status mariadb ● mariadb.service - MariaDB 10.6.10 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: active (running) since Fri 2022-11-04 22:50:42 CST; 38s ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Process: 13728 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 13702 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 13700 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 13714 (mariadbd) Status: "Taking your SQL requests now..." Memory: 61.3M CGroup: /system.slice/mariadb.service └─13714 /usr/sbin/mariadbd Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] InnoDB: 10.6.10 started; log sequence number 42132; transaction id 14 Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] Plugin 'FEEDBACK' is disabled. Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] InnoDB: Buffer pool(s) load completed at 221104 22:50:42 Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] Server socket created on IP: '0.0.0.0'. Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] Server socket created on IP: '::'. Nov 04 22:50:42 serer01 mariadbd[13714]: 2022-11-04 22:50:42 0 [Note] /usr/sbin/mariadbd: ready for connections. Nov 04 22:50:42 serer01 mariadbd[13714]: Version: '10.6.10-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Nov 04 22:50:42 serer01 systemd[1]: Started MariaDB 10.6.10 database server.
六、mariadb的远程连接
1.本地连接
[root@serer01 ~]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.6.10-MariaDB MariaDB Server Copyright (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)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | test | +--------------------+ 5 rows in set (0.002 sec) MariaDB [(none)]>
2.创建用户
MariaDB [(none)]> CREATE USER 'admin'@'%' IDENTIFIED BY 'admin123456'; Query OK, 0 rows affected (0.021 sec) MariaDB [(none)]>
3.对用户授权
MariaDB [(none)]> grant all on *.* to 'admin'@'%' with grant option; Query OK, 0 rows affected (0.020 sec) MariaDB [(none)]> flush privileges; Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]>
4.测试远程连接mariadb数据库
[root@serer01 ~]# mysql -h 192.168.3.169 -P3306 -uadmin -padmin123456 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 5 Server version: 10.6.10-MariaDB MariaDB Server Copyright (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)]>
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。