By default, no sample database TPCC exists in OceanBase. You need to create one manually. The sample database must be created in a business tenant. For more information about the sample database, see About sample database TPCC.
After the tenant is created, you need to create a database to store the sample database objects and grant access permissions to users.
Example
- Connect to a MySQL tenant through OBClient.
#obclient -h192.168.0.0 -uroot@obmysql#obdemo -P2883 -p**1*** -A oceanbase
obclient: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OceanBase monitor. Commands end with ; or \g.
Your OceanBase connection id is 57981
Server version: 5.6.25 OceanBase 2.2.20 (...) (Built Aug 10 2019 15:27:33)
<...Omitted...>
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- Create a database.
obclient> create database tpccdb;
Query OK, 1 row affected (0.02 sec)
obclient> show databases;
+--------------------+
| Database |
+--------------------+
| oceanbase |
| information_schema |
| mysql |
| test |
| tpccdb |
+--------------------+
5 rows in set (0.01 sec)
- Create a user and grant privileges to it.
obclient> grant all privileges on tpccdb.* to tpcc identified by '**1***';
Query OK, 0 rows affected (0.02 sec)
obclient> show grants for tpcc;
+----------------------------------------------+
| Grants for tpcc@% |
+----------------------------------------------+
| GRANT USAGE ON *.* TO 'tpcc' |
| GRANT SELECT ON `oceanbase`.* TO 'tpcc' |
| GRANT ALL PRIVILEGES ON `tpccdb`.* TO 'tpcc' |
+----------------------------------------------+
3 rows in set (0.01 sec)
obclient>
- Create database objects.
obclient> use tpccdb;
Database changed
obclient> source create_mysql_tables.sql
Query OK, 0 rows affected (0.01 sec)
<...Omitted...>
Query OK, 0 rows affected (0.01 sec)
+------------------+
| Tables_in_tpccdb |
+------------------+
| cust |
| dist |
| hist |
| item |
| load_hist |
| load_proc |
| nord |
| ordl |
| ordr |
| stock_item |
| stok |
| ware |
+------------------+
12 rows in set (0.00 sec)
- Initialize table data.
obclient> source init_data.sql
Query OK, 0 rows affected (0.01 sec)
<...Omitted...>
Query OK, 0 rows affected (0.01 sec)
+------------+----------+
| table_name | rows_cnt |
+------------+----------+
| WARE | 2 |
| DIST | 20 |
| NORD | 40 |
| ORDR | 60 |
| HIST | 240 |
| ITEM | 622 |
| ORDL | 626 |
| CUST | 1040 |
| STOK | 1244 |
+------------+----------+
9 rows in set (0.01 sec)