Atom feed of this document
  
 

 Controller setup

On the controller node, install the MySQL client and server packages, and the Python library.

# apt-get install python-mysqldb mysql-server
[Note]Note

When you install the server package, you are prompted for the root password for the database. Choose a strong password and remember it.

The MySQL configuration requires some changes to work with OpenStack.

  • Edit the /etc/mysql/my.cnf file:

    1. Under the [mysqld] section, set the bind-address key to the management IP address of the controller node to enable access by other nodes via the management network:

      [mysqld]
      ...
      bind-address = 10.0.0.11
    2. Under the [mysqld] section, set the following keys to enable InnoDB, UTF-8 character set, and UTF-8 collation by default:

      [mysqld]
      ...
      default-storage-engine = innodb
      collation-server = utf8_general_ci
      init-connect = 'SET NAMES utf8'
      character-set-server = utf8

Restart the MySQL service to apply the changes:

# service mysql restart

You must delete the anonymous users that are created when the database is first started. Otherwise, database connection problems occur when you follow the instructions in this guide. To do this, use the mysql_secure_installation command. Note that if mysql_secure_installation fails you might need to use mysql_install_db first:

# mysql_install_db
# mysql_secure_installation

This command presents a number of options for you to secure your database installation. Respond yes to all prompts unless you have a good reason to do otherwise.

Questions? Discuss on ask.openstack.org
Found an error? Report a bug against this page

loading table of contents...