IBM Worklight v5.0.5 > WL server administration > InstallationCreate MySQL databases
The installer can create the databases if you enter the name and password of the superuser account.
Otherwise, manually create the database instances... Start the MySQL command-line tool and run...
create database wrklght character set utf8 collate utf8_general_ci;
grant all privileges on wrklght.* to 'worklight'@'Worklight-host' identified by 'worklight';
grant all privileges on wrklght.* to 'worklight'@'localhost' identified by 'worklight';
Flush privileges;
create database wlreport character set utf8 collate utf8_general_ci;
grant all privileges on wlreport.* to 'worklight'@'Worklight-host' identified by 'worklight';
grant all privileges on wlreport.* to 'worklight'@'localhost' identified by 'worklight';
Flush privileges;
create database appcntr character set utf8 collate utf8_general_ci;
grant all privileges on appcntr.* to 'worklight'@'Worklight-host' identified by 'worklight';
grant all privileges on appcntr.* to 'worklight'@'localhost' identified by 'worklight';
Flush privileges;Replace Worklight-host with the name of the host on which IBM Worklight runs.
Parent Installation