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

   Copy to Clipboard Toggle word wrap
2. Create the manila database:

   mysql> CREATE DATABASE manila;

   Copy to Clipboard Toggle word wrap
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';

   Copy to Clipboard Toggle word wrap
   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;

   Copy to Clipboard Toggle word wrap
5. Exit the mysql client:

   mysql> quit

   Copy to Clipboard Toggle word wrap
6. Create the Shared File System service tables and apply all necessary migrations:

   # manila-manage db sync

   Copy to Clipboard Toggle word wrap