Execute a script similar to the following as the system DBA.
# Create the database (Schema in MySQL terms) CREATE DATABASE IF NOT EXISTS idm_warehouse CHARACTER SET utf8 COLLATE utf8_bin; # Give permissions to the "idm_warehouse" userid logging in from any host. GRANT ALL PRIVILEGES on idm_warehouse.* TO idm_warehouse IDENTIFIED BY ’idm_warehouse’; # Give permissions to the "idm_warehouse" userid logging in from any host. GRANT ALL PRIVILEGES on idm_warehouse.* TO idm_warehouse@’%’ IDENTIFIED BY ’idm_warehouse’; # Give permissions to the "idm_warehouse" user when it logs in from the localhost. GRANT ALL PRIVILEGES on idm_warehouse.* TO idm_warehouse@localhost IDENTIFIED BY ’idm_warehouse’;
To load the DDL, execute the following command:
# mysql -uidm_warehouse -pidm_warehouse -Didm_warehouse < create_warehouse.mysql