Install and configure controller node in Neutron

[jaya]

This bug tracker is for errors with the documentation, use the following as a template and remove or add fields as you see fit. Convert [ ] into [x] to check boxes:

- [x] This doc is inaccurate in this way: ______

In below part of document:
"Use the database access client to connect to the database server as the root user:
$ mysql -u root -p"

Compared with other project documentation (e.g. initial openstack installation, identity, nova), mysql is executed with root shell user. By executing using root shell user, mysql will not ask for password. and it is inline with other documentation and avoid confusion for new user installing openstack.

so above part should be rewritten as follows:
"Use the database access client to connect to the database server as the root user:
# mysql"

-----------------------------------
Release: 11.0.6.dev59 on 2018-08-02 00:04
SHA: 4eb09e7d786913807c81bdbba6cd968f097a88b5
Source: https://git.openstack.org/cgit/openstack/neutron/tree/doc/source/install/controller-install-ubuntu.rst
URL: https://docs.openstack.org/neutron/pike/install/controller-install-ubuntu.html

[Brian Haley (brian-haley)]

Hi - can you propose a change for this? I can confirm the nova tree uses "# mysql" here.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/589907

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/589907
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=59d178c9de6028016053f2a6958372e14ded386a
Submitter: Zuul
Branch: master

commit 59d178c9de6028016053f2a6958372e14ded386a
Author: Lajos Katona <email address hidden>
Date: Wed Aug 8 11:21:17 2018 +0200

    Remove -u root as mysql is executed with root user

    As openstack installation guides suggest to run mysql with root shell
    user, mysql will not ask for password, so in
    controller-install-*.rst "-u root -p" is useless.

    Change-Id: Ib209661f6dcbbdeb158bd1acf343c084f8ed8930
    Closes-Bug: #1785025

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/neutron 13.0.0.0rc1 release candidate.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/593399
Committed: https://git.openstack.org/cgit/openstack/designate/commit/?id=180a7611f87df74587b718d81b0726cd077bffcf
Submitter: Zuul
Branch: master

commit 180a7611f87df74587b718d81b0726cd077bffcf
Author: zhang.lei <[e-mail]>
Date: Sun Aug 19 14:21:57 2018 +0000

    Remove -u root as mysql is executed with root user

    As openstack installation guides suggest to run mysql with root shell
    user, mysql will not ask for password, so the "-u root -p" is useless.

    Change-Id: I245b8969ec58de91b7d21267bbdf4273d572c8d2
    Related-Bug: #1785025

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.openstack.org/628878

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/628878
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=bc29d4843d5d4a69c2b5e92475a805d218a9c55e
Submitter: Zuul
Branch: master

commit bc29d4843d5d4a69c2b5e92475a805d218a9c55e
Author: Akihiro Motoki <email address hidden>
Date: Mon Jan 7 15:39:42 2019 +0900

    Revert "Remove -u root as mysql is executed with root user"

    This commit was approved just to keep the consistency with
    other OpenStack projects, but most proposed changes related to it
    have been rejected so far [1].
    The main reason is because it is clearer to specify options explicitly
    and we should not assume some configuration.

    I totally agree these opinions and see no reason that neutron
    contineus to use different command line options for mysql.
    Consistency in the installation guide will bring better user experience.

    [1] https://review.openstack.org/#/q/file:%255Edoc/source/install/.*+message:mysql

    This reverts commit 59d178c9de6028016053f2a6958372e14ded386a.

    Related-Bug: #1785025
    Change-Id: I699d03de9e26d5784e6bd5e7d4fa219de6209207

[OpenStack Infra (hudson-openstack)]

Change abandoned by "Erik Olof Gunnar Andersson <email address hidden>" on branch: master
Review: https://review.opendev.org/c/openstack/senlin/+/593459