[common] Access denied for user 'root'@'127.0.0.1' (using password: YES) when create database

[Feng Ju]

I got this error: Access denied for user 'root'@'127.0.0.1' (using password: YES) when I install all-in-one in the clean centos box.
I checked the mysqld's user table, found that 127.0.0.1 is not allowed to access using password.
mysql> select * from user;
+-----------+------+-------------------------------------------+-------------+-
| Host | User | Password | Select_priv |
+-----------+------+-------------------------------------------+-------------+-
| localhost | root | *CF15582E59A4C338FF403EF9E2D7924EE07328A9 | Y |
| centos64 | root | | Y |
| 127.0.0.1 | root | | Y |
| localhost | | | N |
| centos64 | | | N |
| % | repl | *43B02C91B1222E92ABE80A90C4CE6DF1230106D5 | N |
| % | root | *CF15582E59A4C338FF403EF9E2D7924EE07328A9 | Y |
+-----------+------+-------------------------------------------+-------------+-
7 rows in set (0.00 sec)

I don't know if someone run into this, but I think we need to update openstack-common cookbook to solve the issue when we test the cookbooks.

[OpenStack Infra (hudson-openstack)]

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

[Richard Theis (rtheis)]

I ran into the same problem, but was told it may be something in my vagrant setup. I worked around it in the same way that you fixed it.

[Mark Vanderwiel (vanderwl)]

This is handled by https://review.openstack.org/#/c/67840/, please close out this bug.