环境:
OS:Centos 7
oceanbase:4.2
192.168.1.105 中控机
192.168.1.106
192.168.1.107
1.下载离线包(中控机执行)
https://www.oceanbase.com/product/opensource
下载的介质为:
oceanbase-all-in-one-4.2.0.0-100120230821114201.el7.x86_64.tar.gz
2.安装java 1.8以上版本
2.解压(中控机执行)
[root@localhost soft]# tar -xzf oceanbase-all-in-one-*.tar.gz
[root@localhost soft]# cd oceanbase-all-in-one/bin/
[root@localhost soft]# ./install.sh
#####################################################################
Install Finished
=====================================================================
Setup Environment: source ~/.oceanbase-all-in-one/bin/env.sh
Start Web Service: obd web
Quick Start: obd demo
More Details: obd -h
=====================================================================
[root@localhost soft]# source ~/.oceanbase-all-in-one/bin/env.sh
3.启动白屏界面(中控机执行)
命令行执行 obd web 命令启动白屏界面，单击输出的地址访问白屏界面
在白屏界面中单击 开启体验之旅 即可进入到 OceanBase 数据库的配置界面.
[root@localhost soft]# obd web
[root@localhost bin]# obd web
start OBD WEB in 0.0.0.0:8680
please open http://127.0.0.1:8680
我这里服务器ip是192.168.1.105,浏览器打开如下地址:
http://192.168.1.105:8680/
4.创建用户
[root@localhost ~]#obclient -h192.168.1.105 -P2881 -uroot -p'mysql123' -Doceanbase -A
obclient [oceanbase]> grant all privileges on *.* to 'hxl'@'%' identified by 'mysql' WITH GRANT OPTION;
Query OK, 0 rows affected (0.827 sec)