14.5. Create the Shared File System Service Database

Procedure 14.2. Creating the Shared File System Service Database

1. Connect to the database service:

   # mysql -u root

2. Create the manila database:

   mysql> CREATE DATABASE manila;

3. Create a manila database user and grant the user access to the manila database:

   mysql> GRANT ALL ON manila.* TO 'manila'@'%' IDENTIFIED BY 'MANILADBPASS';
   mysql> GRANT ALL ON manila.* TO 'manila'@'localhost' IDENTIFIED BY 'MANILADBPASS';

   Replace MANILADBPASS with a secure password that the manila service can use to authenticate with the database server. You will use this same password later in Section 14.4, “Configure Basic Shared File System Service Settings”.
4. Flush the database privileges to ensure that they take effect immediately:

   mysql> FLUSH PRIVILEGES;

5. Exit the mysql client:

   mysql> quit

6. Create the Shared File System service tables and apply all necessary migrations:

   # manila-manage db sync