[common] Access denied for user 'root'@'127.0.0.1' (using password: YES) when create database
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack + Chef |
Fix Released
|
Medium
|
Feng Ju |
Bug Description
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 | *CF15582E59A4C3
| centos64 | root | | Y |
| 127.0.0.1 | root | | Y |
| localhost | | | N |
| centos64 | | | N |
| % | repl | *43B02C91B1222E
| % | root | *CF15582E59A4C3
+------
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.
summary: |
- Access denied for user 'root'@'127.0.0.1' (using password: YES) when - create database + [common] Access denied for user 'root'@'127.0.0.1' (using password: YES) + when create database |
Changed in openstack-chef: | |
importance: | Undecided → Medium |
Changed in openstack-chef: | |
status: | In Progress → Fix Committed |
no longer affects: | openstack-chef/havana |
Changed in openstack-chef: | |
status: | Fix Committed → Fix Released |
Fix proposed to branch: master /review. openstack. org/68351
Review: https:/