2.4.1 Creating MySQL databases and users

MySQL is used by both the Daisy Repository Server and OpenJMS. Therefore, we are now going to create two databases and two users.

Open a command prompt, and start the MySQL client as root user:

mysql -uroot -pYourRootPassword

On some systems, the root user has no password, in which case you can drop the -p parameter.

Now create the necessary databases, users and access rights by entering (or copy-paste) the commands below in the mysql client. What follows behind the IDENTIFIED BY is the password for the user, which you can change if you wish. The daisy@localhost entries are necessary because otherwise the default access rights for anonymous users @localhost will take precedence. If you'll run MySQL on the same machine as OpenJMS and the Daisy Repository Server, you only need the @localhost entries.

CREATE DATABASE daisyrepository;
GRANT ALL ON daisyrepository.* TO daisy@'%' IDENTIFIED BY 'daisy';
GRANT ALL ON daisyrepository.* TO daisy@localhost IDENTIFIED BY 'daisy';
CREATE DATABASE openjms;
GRANT ALL ON openjms.* TO openjms@'%' IDENTIFIED BY 'openjms';
GRANT ALL ON openjms.* TO openjms@localhost IDENTIFIED BY 'openjms';