Chapter 4. Create the database

As a first step you must create the database. This can be done with MySQL Administrator. Start MySQL Administrator. Select Catalogs and then Create New Schema from the popup menu as shown in Figure 4-1.

Figure 4-1. Create a new database schema.

enlarge

Enter crx-CRX as database name as shown in Figure 4-2 and click OK.

Figure 4-2. Create the schema crx-CRX.

enlarge

Next you must create a database user and grant this user access to the newly created database. Select User Administration and then Add new User from the poup menu as shown in Figure 4-3.

Figure 4-3. Create a new database user.

enlarge

Complete the Login Information and Additional information. We assume that you create the user system and set the password to manager.

Next you must grant the user system access to the database crx-CRX. Select the tab Schema Privileges and then select the schema crx-CRX. Move all privileges from the pane Available Privileges to the pane Assigned Privileges and click Apply changes as shown in Figure 4-4.

Figure 4-4. Create the user system and grant permissions.

enlarge

You are now done creating the database.