I am using Drupal 7.56 and CiviCRM 4.7.21 on Ubuntu 16.04. The Apache and MySQL servers run on the same host.
The Drupal and CiviCRM databases are stored on the same server, and are accessed with a single user. Drupal is happy and works just fine. But CiviCRM, using the same user as Drupal, cannot connect to the database.
The error message appears under the headings "CiviCRM Database Details" and "Drupal Database Details", in the following row:
Are the access credentials correct? | That username/password doesn't work:
Here's what I've done so far
- I have triple checked that I am not making any typos.
- I have verified that I can log into the MySQL account using the MySQL shell.
- I have verified that MySQL is listening on the default port.
- I have verified that MySQL is binding to 127.0.0.1.
- I have verified that there is no firewall in the way.
- I have tried out opening the server to remote connections and making the MySQL user able to log in remotely. I successfully connected with Sequel Pro, but CiviCRM didn't budge. I closed things down again.
I am a loss for what else I can try. Is there something special about how CiviCRM connects to MySQL? After all, Drupal is having no problems.
I notice that the error message ends with a colon, which implies that there is supposed to be some additional information. Does this imply that there may be a bug?
Thanks very much!