New instance of Octopus can't find db password [#1868492]

I am unable to create a new Octopus instance. The installation script stops after it confirms details and signals it is ready to install.

Do you really want to proceed with the install (y/n): y
SQLSTATE[28000] [1045] Access denied for user 'broadway'@'localhost' ^[[31;40m^[[1m[error]^[[0m
(using password: YES)
Unable to connect to database server.

I changed the root database password a long time ago and do not recall running into any problems since then. I am able to log into the db via command line and Chive using the changed password. When I changed the password I modified /root/.my.pass.txt and /root/.my.cnf to reflect the new password and I have confirmed they still show the correct one.

Is there some other place the root db password is stored that was not changed? Or is the password problem only a symptom of another issue?

Log details can be found at https://gist.github.com/4318254.

Comments

Comment #1

omega8cc CreditAttribution: omega8cc commented 19 December 2012 at 02:34

Component:

Code

» Miscellaneous

No idea, it should work out of the box, but you should know that changing your mysql root password is a bad idea. Maybe you have modified the grant so it no longer works as expected? Do you have any special characters in that password which could cause some issues? I would debug this by changing the password to some simple A-Z0-9a-z and then try again.

Or better yet, make sure if you have really changed the password for all mysql root user grants - there are three: one for localhost, another for 127.0.0.1 and third for ::1 .