Linux系统之安装mariadb方法

举报
江湖有缘 发表于 2022/12/05 14:40:34 2022/12/05
【摘要】 Linux系统之安装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)]> 

【版权声明】本文为华为云社区用户原创内容,转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息, 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@huaweicloud.com
  • 点赞
  • 收藏
  • 关注作者

评论(0

0/1000
抱歉,系统识别当前为高风险访问,暂不支持该操作

全部回复

上滑加载中

设置昵称

在此一键设置昵称,即可参与社区互动!

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。