13.5. Create the File Share Service Database

Create a database and database user for the File Share Service. All steps must be performed on the database server, while logged in as the root user.

Procedure 13.2. Creating the File Share 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 13.4, “Configure Basic File Share 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 File Share Service tables and apply all necessary migrations: 
    # manila-manage db sync