OrientDB基本使用

 官网下载orientdb-3.1.10.zip，解压E:\Programs\orientdb-3.1.10\bin,启动服务器server.bat

其他安装方式参考https://orientdb.com/docs/last/admin/installation/

服务端：

orientdb-server-config.xml 配置端口，默认如下两个端口

• Binary: OrientDB listens on port 2424 for binary connections from the console and for clients and drivers that support the Network Binary Protocol.

• HTTP: OrientDB listens on port 2480 for HTTP connections from OrientDB Studio Web Tool and clients and drivers that support the HTTP/REST protocol, or similar tools, such as cURL.

第一次提示输入root账号密码输入后保存到orientdb-server-config.xml的user节点。后续创建数据库、列数据库都需要用root账号和此密码。如果账号密码输入错误connet并没有报错，都是提示OK，

后面进行查询数据库时候就会报错权限不足。

使用console.bat控制台命令来连接数据库

Type 'help' to display all the supported commands.
orientdb> CONNECT remote:localhost root su*****12
OK
orientdb {server=remote:localhost}> list databases

Found 1 databases:

* demodb
orientdb {server=remote:localhost/test}> CREATE DATABASE remote:localhost/test admin admin

Creating database [remote:localhost/test] using the storage type [PLOCAL]...
Error: com.orientechnologies.orient.core.exception.OSecurityAccessException: Wrong user/password to [connect] to the remote OrientDB Server instance

orientdb {server=remote:localhost/test}> CREATE DATABASE remote:localhost/test root suo****12

Creating database [remote:localhost/test] using the storage type [PLOCAL]...
Database created successfully.

Current database is: remote:localhost/test
orientdb {db=test}>

也可以通过图形化进行访问，这里默认数据库demodb的用户和密码是admin、admin。可以登录后security的tab页进行admin账号密码修改。

创建数据库的账户密码也不能随便输，而是用root账号来创建。test数据库创建后也是有默认如下用户（密码和用户名相同），用如下用户就可以登录test数据库。

直接连接某个数据库 

orientdb {db=test}> CONNECT remote:localhost/demodb admin admin

Disconnecting from the database [test]...OK
IMPORTANT! Using default password is unsafe, please change password for user 'admin' on database 'demodb'
Connecting to database [remote:localhost/demodb] with user 'admin'...OK
orientdb {db=demodb}>

如果在服务器可以使用本地方式连接，效率更高

orientdb> connect plocal:E:/Programs/orientdb-3.1.10/databases/test admin admin
IMPORTANT! Using default password is unsafe, please change password for user 'admin' on database 'test'
Connecting to database [plocal:E:/Programs/orientdb-3.1.10/databases/test] with user 'admin'...
2021-04-13 16:54:12:121 WARNI IMPORTANT! Using default password is unsafe, please change password for user 'admin' on database 'test' [OrientDBEmbedded]
2021-04-13 16:54:12:567 WARNI Storage 'test' was not closed properly. Will try to recover from write ahead log [OLocalPaginatedStorage]
2021-04-13 16:54:17:757 WARNI Record com.orientechnologies.orient.core.storage.impl.local.paginated.wal.common.EmptyWALRecord{lsn_operation_id=OperationIdLSN{operationId=471, lsn=OLogSequenceNumber{segment=7, position=22}}} will be skipped during data restore [OLocalPaginatedStorage]OK
orientdb {db=test}>