In MySQL Query Browser or MySQL Command Line, execute the following script to create database ‘doccare’:
|
create database if not exists doccare; |
Execute the following script to create access info for database 'doccare'.
|
grant select,insert,update,delete,create,drop,alter,references,index on doccare.* to 'doccare'@'127.0.0.1' identified by 'doccare'; grant select,insert,update,delete,create,drop,alter,references,index on doccare.* to 'doccare'@'localhost' identified by 'doccare'; flush privileges; |
If your MySQL is running on another host,you should add the host where DocCare runs to the permitted hosts list, in order to allow the user from that host to access the database.
|
grant select,insert,update,delete,create,drop,alter,references,index on doccare.* to 'doccare'@'hostname' identified by 'doccare'; flush privileges; |
To test the access info you created for DocCare2, do the operation below:
From command line (localhost):
|
[burgeonsoft][~]$mysql –r doccare –pdoccare |
From command line (other host):
|
[burgeonsoft][~]$mysql –r doccare –h hostname –pdoccare |
Or from MySQL Query Browser (localhost):
You should be able to connect to MySQL server.
For installation over Oracle or MS SQL Server, please contact Burgeonsoft Support.