南大通用数据库-Gbase-8a-学习-00-单机版安装

一、测试环境

名称	值
cpu	Intel® Core™ i7-7700HQ CPU @ 2.80GHz
操作系统	Red Hat Enterprise Linux Server release 7.9 (Maipo)
Gbase-8a版本	8.6.2.43-R7-free.110605

二、相关资料下载

云盘包含：
（1）Gbase-8a-相关文档资料。
（2）Gbase-8a-单机版本安装包。
（3）GBase-8a企业管理器。

链接：https://pan.baidu.com/s/1ZfeRJoC6U7UV3OxwlAXxGQ 
提取码：pmpp

三、安装步骤

1、创建操作系统用户

[root@node0 opt]# groupadd gbase -g 2006

[root@node0 opt]# useradd gbase -g 2006 -u 2006

[root@node0 opt]# echo "gbase"|passwd --stdin gbase

2、创建目录并解压

[root@node0 opt]# mkdir /opt/Gbase-8a

[root@node0 opt]# tar -xvf /opt/pkg/GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2 -C /opt/Gbase-8a/

3、修改目录用户组

[root@node0 opt]# chown -R gbase:gbase /opt/Gbase-8a/

4、安装数据库

[root@node0 GBaseInstall]# su - gbase

[gbase@node0 ~]$ cd /opt/Gbase-8a/GBaseInstall/

[gbase@node0 GBaseInstall]$ ./Install_lin.sh 

*********************************************************************************
Thank you for choosing GBase product!

Please read carefully the following licencing agreement before installing any product:

Disclaimer of Product Trial License:
1. Any user who tries out (including self-downloaded trial or trial version provided by General Data Technology Co., Ltd) General Data Technology
 Co., Ltd Software Products should read this statement carefully. Users may choose not to try Nanda General Software Products. The user's tries out General Data Technology Co., Ltd Software Products will be deemed to be an endorsement of the full content of this statement.2. Universal software products of General Data Technology Co., Ltd have complete autonomous knowledge rights and do not infringe on the relevant 
rights and interests of any other unit or individual. Universal software products of General Data Technology Co., Ltd are protected by law. Any transfer, reproduction, dissemination or use in unauthorized projects are strictly prohibited without the written permission of Universal of Nanda. Otherwise, the infringer will bear full responsibility.3. Except for the terms of service specified by General Data Technology Co., Ltd, General Data Technology Co., Ltd is not liable or liable for an
y accident, negligence, contract destruction, defamation, copyright or intellectual property infringement caused by the trial use of General Data Technology Co., Ltd software products and any losses (including virus infection due to downloading).4. The relevant information of General Data Technology Co., Ltd Software Products is the original information released. If there are any changes,
 no further notice will be given. Software may run differently from the final version, and features and functions in pre-release software may not appear in the final version. The risk of trying out the software should be borne by you.5. Users assume their own risks for the trial of General Data Technology Co., Ltd Software Products. General Data Technology Co., Ltd does not gu
arantee any form of guarantee, does not guarantee that the trial products meet the user's requirements, does not guarantee that the trial service is uninterrupted, and does not guarantee the safety of the trial products. Due to any technical reasons such as network status, communication lines and so on, users can not normally try out General Data Technology Co., Ltd Products, or the impact or loss on third parties in the process of trial, General Data Technology Co., Ltd does not bear any legal liability.6. General Data Technology Co., Ltd respects and protects the personal privacy rights of all users who try out General Data Technology Co., Ltd P
roducts. Without the personal permission of users or mandatory provisions of relevant laws, General Data Technology Co., Ltd will not voluntarily disclose other third parties.7. Any unit or individual who considers that General Data Technology Co., Ltd Software products may be suspected of infringing on its legitimate 
rights and interests should promptly give written feedback to General Data Technology Co., Ltd or its service website, and provide identity certificates, ownership certificates and detailed tort proof. After receiving the verification of the above-mentioned legal documents, General Data Technology Co., Ltd l will make corresponding treatment as soon as possible.8. General Data Technology Co., Ltd Corporation has the final right to interpret General Data Technology Co., Ltd Products and this statement.
*********************************************************************************
Do you accept the above licence agreement (Yes/No, default=No) ?
yes

*********************************************************************************
                     Welcome to install GBase products
*********************************************************************************
Please input the GBase software installation directory (Default:/home/gbase/GBase):


Installing all software packages ...

Software packages installation done.

*********************************************************************************
                  Welcome to create GBase database instance
*********************************************************************************
Please input the new database instance name (default: gbase8a):


Please input the port number for the new database instance (default:5258):

GBase is creating the New 'gbase8a' instance ...

hostkey: 8872b892ef10d9e1ed5cdbfca85298b2
The host key file is genarate at GBASE_BASE/config/gbase_host.cnf.


Congratulations.  Your GBase installation is successful.

Please execute $source ~/.bashrc manually on the first run.

Please refer to the product's manuals and readme.txt to start using GBase product.

5、配置环境变量

[gbase@node0 GBaseInstall]$ vim /home/gbase/.bashrc

添加如下内容：

export GBASE_BASH=/home/gbase/GBase
export GBASE_HOME=/home/gbase/GBase/server
export GBASE_SID=gbase8a
export PATH=$GBASH_HOME/bin:$PATH

使环境变量在当前会话立即生效

[gbase@node0 GBaseInstall]$ source /home/gbase/.bashrc

6、启动数据库

[root@node0 GBaseInstall]# su - gbase

[gbase@node0 GBaseInstall]$ gbase.server --help
Usage: /home/gbase/GBase/server/bin/gbase.server  {start|stop|restart}  [ GBase server options ]

[gbase@node0 GBaseInstall]$ gbase.server start
Starting GBase. SUCCESS!

7、登录数据库

默认数据库root用户密码为空，我们回车即可，保险起见我们自己配置一下root的密码。

[gbase@node0 GBaseInstall]$ gbase -uroot -p
Enter password: 

GBase client Free Edition 8.6.2.43-R7-free.110605. Copyright (c) 2004-2022, GBase.  All Rights Reserved.

gbase> alter user root identified by 'qwer1234';
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase>

8、创建数据库及用户

gbase> create database czg;
Query OK, 1 row affected (Elapsed: 00:00:00.00)

gbase> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| czg                |
| gbase              |
| gclusterdb         |
| gctmpdb            |
+--------------------+
6 rows in set (Elapsed: 00:00:00.00)

gbase> use czg;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase> create user czg identified by 'qwer1234';
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase> grant all on *.* to 'czg'@'%';
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase> select * from gbase.user where user = 'czg'\G ;
*************************** 1. row ***************************
                   Host: %                                                           
                   User: czg             
               Password: *D75CC763C5551A420D28A227AC294FADE26A2FF2
            Select_priv: Y
            Insert_priv: Y
            Update_priv: Y
            Delete_priv: Y
            Create_priv: Y
              Drop_priv: Y
            Reload_priv: Y
          Shutdown_priv: Y
           Process_priv: Y
              File_priv: Y
             Grant_priv: N
        References_priv: Y
             Index_priv: Y
             Alter_priv: Y
           Show_db_priv: Y
             Super_priv: Y
  Create_tmp_table_priv: Y
       Lock_tables_priv: Y
           Execute_priv: Y
        Repl_slave_priv: Y
            Unmask_priv: Y
       Create_view_priv: Y
         Show_view_priv: Y
    Create_routine_priv: Y
     Alter_routine_priv: Y
       Create_user_priv: Y
             Event_priv: Y
           Trigger_priv: Y
               ssl_type: 
             ssl_cipher: 
            x509_issuer: 
           x509_subject: 
          max_questions: 0
            max_updates: 0
        max_connections: 0
   max_user_connections: 0
               max_cpus: 0
           max_memories: 0
          max_tmp_space: 0
         resource_group: 0
          task_priority: 2
user_limit_storage_size:                
      user_storage_size: 0
                    UID: 4
1 row in set (Elapsed: 00:00:00.00)

gbase> select version();
+-------------------------+
| version()               |
+-------------------------+
| 8.6.2.43-R7-free.110605 |
+-------------------------+
1 row in set (Elapsed: 00:00:00.00)