MySQL is accessed as Root

Bug #1118502 reported by Adam Young on 2013-02-07

This bug report was converted into a question: question #233728: MySQL is accessed as Root.

10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
devstack
Undecided
Unassigned

Bug Description

devstack uses root as the mysql database user

specifically for keystone, the sql connection string is

connection = mysql://root:badpass@localhost/keystone?charset=utf8

This should be the devstack user, not root.

In addition, devstack tries to do administrative operations as root:

 sudo mysqladmin -u root password keystone
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Which causes devstack to fail

Adam, Is there a log i can look at?

Roman Gorodeckij (holms) wrote :

Ok i had the same problem. and point was that I did ./stack.sh second time with different localrc. mysqld was started and ofcourse it's failed to connect because root user was created before with different password.

I deleted mysql-server and reinstalled everything completely. And now it's moved further.

Changed in devstack:
status: New → Confirmed
Roman Gorodeckij (holms) wrote :

This not probably a bug. By nature devstack is written with shell script, so ofcourse performing the same setup on top will fail.
Devstack really should move to puppet.

Changed in devstack:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Related questions