Install and configure in Installation Guide

[cargonza]

I'm stepping through the MYSQL configuration: http://docs.openstack.org/newton/install-guide-ubuntu/keystone-install.html

Stepping through "$ mysql -u root -p" this command does not work out of the box. There seems to be a bug with mysql where you have to clear the root password by utilizing the steps outlined http://superuser.com/questions/949496/cant-reset-mysql-mariadb-root-password in this page in order to get into the database.

MariaDB [mysql]> Use mysql
MariaDB [mysql]> SELECT user, plugin FROM user;
UPDATE user SET plugin="";
UPDATE user SET password=PASSWORD("my_password") WHERE user="root";
FLUSH PRIVILEGES;

$ sudo service mysql restart

I think its well worth nothing the issue here in order to make the experience a bit easier for the user. Initially, I was having a painless experience going through the documentation steps. However, the above was my first challenge which resulted in deciding on opening a bug. There were some minor items but it was small compared to this one.

-----------------------------------
Release: 0.1 on 2016-11-17 09:11
SHA: fee9331b58b9dd551d5bf2d889d35811d5b9d0ce
Source: http://git.openstack.org/cgit/openstack/openstack-manuals/tree/doc/install-guide/source/keystone-install.rst
URL: http://docs.openstack.org/newton/install-guide-ubuntu/keystone-install.html

[Alexandra Settle (alexandra-settle)]

I see, since this is a bug in mysql we should definitely include a notation explaining this.

Fix: Include a note in http://docs.openstack.org/newton/install-guide-ubuntu/keystone-install.html explaining that there is a known issue with mysql and password resets. See above link for more context.

[Phil Hopkins (phil-hopkins-a)]

MariaDB is by default now using a unix_socket to connect to the database server. This eliminates the need for a password for the root user. As such the install manual is correct, you should be root when performing these commands. As root you will not need a password to connect to the database, nor can you set one to be used in this context.

Please see bug - https://bugs.launchpad.net/openstack-manuals/+bug/1647848

[Phil Hopkins (phil-hopkins-a)]

This is one of several bugs posted regarding the same issue. This problem will be resolved in:
https://bugs.launchpad.net/openstack-manuals/+bug/1647848

Closing this bug report.

Phil