Create Database Schema and User

This help introduces how to create a HSQLDB or MySQL schema and user.
If you plan to use other database servers, such as Oracle or MS SQL Server, please contact usContact Burgeonsoft.

HSQLDB

DocCare installation package has already contained an embedded HSQL DB 1.8 database server and created schema for you. You don't have to manually create schema for DocCare.
You can edit JDBC configuration to connection HSQLDB in an exclusive way or by TCP/IP. If you plan to connect HSQLDB in TCP/IP, you should start the HSQLDB before you start DocCare. The JDBC configuration is store in ${BURGEON_HOME}/conf/database.properties
The default use is sa, password is blank.
You can change the default database user and password by yourself. Detail to seehttp://hsqldb.org/web/hsqlDocsFrame.html。

MySQL5.1 or later version

If you plan to use MySQL database, you should download the suitable MySQL database driver, and create a schema before install DocCare.
You can create a schema by executing the following command in MySQL command line or MySQL Query Browser.

create schema doccare_v3;

'doccare_v3' is the schema name.

If your MySQL database server is installed on the same physical machine as DocCare server, you can execute the following commands to create a database user for the schema 'doccare_v3'.

grant select,insert,update,delete,create,drop,alter,references,index,create view,show view,execute on doccare_v3.* to 'dcuser'@'127.0.0.1' identified by 'dcpwd';
grant select,insert,update,delete,create,drop,alter,references,index,create view, show view, execute on doccare_v3.* to 'dcuser'@'localhost' identified by 'dcpwd';
flush privileges;

The above commands created a user named 'dcuser'. He can connect to the schema 'doccare_v3' from the local machine, the password is 'dcpwd'.

If you install MySQL server on a different physical machine from DocCare server, you can execute the commands below to create a user who can connect to schema 'doccare_v3' from a specific remote host.

grant select,insert,update,delete,create,drop,alter,references,index ,create view,show view, execute on doccare_v3.* to dcuser@'hostname' identified by 'dcpwd';
flush privileges;

'hostname' is the host name or IP address of the DocCare server.

You can test if the schema, user and password are correct like below.
For a local MySQL server, you can type:

[burgeonsoft][~] mysql -u dcuser –pdcpwd

For a remote MySQL server, you can type:

[burgeonsoft][~] mysql -u dcuser -h hostname –pdcpwd

If the host name, user and password are correct, you can successfully connect to the MySQL server.

You also can test the connection by using MySQL Query Browser.
登录MySQL Query Browser
If the host name, user and password are correct, you can successfully connect to the MySQL server.

Help Center

Create Database Schema and User

HSQLDB

MySQL5.1 or later version