Create Users

Create sa user:

grant all privileges on *.* to 'sa'@'%' identified by 'secret' with grant option;

This user will be used by the system administrator.

Create penrose user:

grant all privileges on *.* to 'penrose'@'%' identified by 'penrose' with grant option;

This user will be used for penrose to modify the database.

Create Databases

Create a database called "example" and initialize it with the following scripts which can be found in PENROSE_SERVER_HOME\samples\sql:

• example.sql
• triggers.sql

Create an empty database called "penrose" to store cache data.

These databases can be created on different machines.