I’ve got an app that talks to two databases on a given MySQL server.
When I run in development mode, pointing to the MySQL server running
on localhost (127.0.0.1),
I am able to access both databases without any problem. The relevant
yaml looks like this:
(names have been changed to protect the innocent)
When I change the environment to “production”, I am unable to access
the database that is not named “production”. I get an error that
reads “Mysql::Error: Unknown database ‘prod2’”. The production part
of the yaml looks like:
When I change the “development” and “dev2” to point to the production
server and tables, I get the same error.
This leads me to believe that the dev and prod mysql servers are
configured differently, but I wanted to double check and see if anyone
has seen this problem before (and that it might be rails).