MySQL is accessed as Root

Bug #1118502 reported by Adam Young

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
Invalid
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

Revision history for this message
Davanum Srinivas (DIMS) (dims-v) wrote :

Adam, Is there a log i can look at?

Revision history for this message
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
Revision history for this message
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  
Everyone can see this information.

Other bug subscribers

Related questions

Remote bug watches

Bug watches keep track of this bug in other bug trackers.