Kilo MySQL mysqld_openstack.cnf on Ubuntu

asked 2015-05-09 14:43:10 -0600

YanivZadka2 gravatar image

Trying to install Kilo on Ubuntu 14.04 multi-node environment I encountered with the following in the documentation "Create and edit the /etc/mysql/conf.d/mysqld_openstack.cnf file and complete the following actions" I suspect that the instructions should be

  1. cp /etc/mysql/my.cnf /etc/mysql/conf.d/mysqld_openstack.cnf
  2. Edit mysqld_openstack.cnf with the following [mysqld] bind-address = default-storage-engine = innodb innodb_file_per_table collation-server = utf8_general_ci init-connect = 'SET NAMES utf8' character-set-server = utf8

Anyone encountered with the same issue? If so, what workaround you used?

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2015-06-22 12:59:19 -0600

Napo Mokoetle gravatar image

The order in which configuration files are read is specified in this config file on UBUNTU 1504 /etc/mysql/my.cnf

root@ts03695:/home/pssuser# cat /etc/mysql/my.cnf

The MariaDB configuration file


The MariaDB/MySQL tools read configuration files in the following order:

1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,

2. "/etc/mysql/conf.d/*.cnf" to set global options.

3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.

4. "~/.my.cnf" to set user-specific options.


If the same option is defined multiple times, the last one will apply.


One can use all long options that the program supports.

Run program with --help to get a list of available options and with

--print-defaults to see which it would actually understand and use.

Import all .cnf files from configuration directory

!includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mariadb.conf.d/

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools



Asked: 2015-05-09 14:43:10 -0600

Seen: 2,025 times

Last updated: Jun 22 '15