6.0 Configuring and Maintaining the MySQL Database Appliance

This section describes how to change configuration options for the MySQL database appliance for a large deployment, including how to change the credentials for the MySQL database.

If you already have a MySQL database server that you want the Filr appliance to use, you can skip this section and update the configuration as described in Section 2.2.3, Configuring an Existing MySQL Database.

IMPORTANT:In a production environment, it is a best practice to change the credentials for the MySQL database when the MySQL database is running as a separate appliance. If you do not change the credentials, you at least need to change the root password for the MySQL database.

If your MySQL database is configured on the same appliance as your Filr application, you make configuration changes on the Filr appliance, as described in Section 4.0, Configuring and Maintaining the Filr Appliance.

  1. After installing the database appliance, as described in Section 2.2.2, Installing the MySQL Database Appliance, navigate to the following URL:

    https://ip_address:9443

    Replace ip_address with the IP address of your database appliance.

  2. Sign in to the database appliance. The default username is root, and the default password is the password that you specified during installation.

    The Novell MySQL Appliance landing page is displayed.

  3. Click the phpMyAdmin icon, then click Go to log in to phpMyAdmin.

  4. Log in to the phpMyAdmin tool as the root user. (The default password for the root user is root. You will be instructed to change the default password in a future step.)

  5. (Recommended) Create a new Filr user to administer the MySQL database:

    1. At the top of the page, click Users.

    2. Click Add user.

    3. In the User name field, specify filr as the new user.

    4. In the Host field, select Use text field in the drop-down list, then specify the IP address or host name of the Filr application server.

    5. In the Password field, specify a new password for the user, then confirm it in the Re-type field.

    6. In the Database for user section, select Create database with same name and grant all privileges.

    7. Click Add user. Note the username and password of this user. This is the user you will use to access the MySQL database when you configure the Filr appliance.

      You can now administer the Filr MySQL database by using this new user.

  6. (Conditional) If you have a clustered Filr system with multiple Filr appliances, you must create a new user for each Filr appliance in the cluster. You do this by editing the privileges for the user that you created in Step 5:

    1. On the Users overview page, click Edit Privileges next to the user that you created in Step 5.

    2. Scroll to the Login Information section, and in the Host field, specify the IP address or host name of the next Filr appliance in the cluster.

    3. In the Create a new user with the same privileges and... section, ensure that ...keep the old one is selected, then click Go.

    4. Repeat Step 6.a through Step 6.c for each Filr appliance in the cluster.

  7. (Recommended) Change your MySQL root password if you have not done so already:

    1. At the top of the page, click Users.

    2. In the Users Overview table, locate the root user with % in the Host column, then click Edit Privileges for that user in the Action column.

    3. Scroll to the Change password section. In the Password field, specify your password, then confirm it in the Re-type field.

    4. Click Go.

  8. Make any other configuration changes.

  9. (Conditional) If this is the first time you have configured the MySQL database appliance:

    1. Ensure that you have configured the search index appliance, as described in Section 5.0, Configuring and Maintaining the Search Index Appliance.

    2. Configure the Filr appliance, as described in Section 3.0, Configuring Filr for the First Time.

      The MySQL database appliance and the Search Index appliance must already be installed and configured before you can configure the Filr appliance for the first time.