Creating the database
To avoid problems at a later stage, make sure you set your database to use a character encoding that is suitable for your language. The examples here will use utf-8. Please notice that 8-bit ASCII encoding is generally a poor choice and should be avoided.
You can use the graphical DBCA (Database Configuration Assistant) to create a database called 'portofinodb' or you can run the SQL commands manually as follows.
% sqlplus CREATE USER username IDENTIFIED BY password; CREATE DATABASE portofinodb NATIONAL CHARACTER SET utf8; GRANT ALL PRIVILEGES TO username;
You can use the graphical SQL Server Enterprise Manager to create a new database called 'portofinodb'.
You can use the graphical DB2 Control Center (db2cc) to create a new database called 'portofinodb' or you can run the command line instructions as follows.
% db2 CREATE DATABASE portofinodb USING CODESET UTF-8 TERRITORY US PAGESIZE 32 k UPDATE DB CFG FOR portofinodb USING APP_CTL_HEAP_SIZE 4000
You can use the graphical pgadmin tool to create a new database called 'portofinodb' or you can run the command line instructions as follows.
% psql CREATE USER username WITH PASSWORD 'password'; CREATE DATABASE portofinodb WITH OWNER=username ENCODING='UTF8';
You can use a graphical tool like MySQL Administrator, MySQL Query Browser or phpmyadmin to create two databases called 'model' and 'meta'. Or you can follow these command line instructions:
% mysql -uroot -p SET CHARACTER SET 'UTF8'; SET sql_mode = 'ANSI'; CREATE DATABASE model CHARACTER SET "UTF8"; CREATE DATABASE meta CHARACTER SET "UTF8";Create the application's user and grant it all privileges on the two databases:
grant all on model.* to username@localhost identified by 'password'; grant all on meta.* to username@localhost; grant all on model.* to username@'%' identified by 'password'; grant all on meta.* to username@'%';
With Derby there is no need to create the database upfront. If will be created automatically during the first connection if you specify the 'create=true' parameter. See basic configuration for more details.