MySQL (ClearDB) does not work on Heroku

Question

I have multiple (FREE) apps on Heroku, all of them using PHP and MySQL. However, on one of them I constantly have issues with ClearDB (MySQL). I get the following error

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

When I try to connect to it from my local machine, it works fine. I have tried removing the ClearDB addon and adding it again multiple time, but this hasn't solved the issue. This has been going on for about 3 weeks now.

Here is my code:

    public $production = array(
    'datasource' => 'Database/Mysql',
    'persistent' => false,
    'host' => 'us-cdbr-east-04.cleardb.com',
    'login' => 'username',
    'password' => 'password',
    'database' => 'heroku_9565d18e1870f97',
    'prefix' => '',
    //'encoding' => 'utf8',
);

and here is the URL I get from Heroku/ClearDB

mysql://username:[email protected]/heroku_9565d18e1870f97?reconnect=true

Any ideas what to do now? Does my code look right? I can probably ask Heorku's support, but I would rather ask the community first, since I am not paying for Heroku at the moment.

Answer 1

Look like your connection string might be missing or wrong.

The ClearDB addon sets an environment variable called CLEARDB_DATABASE_URL. It contains the mysql connection string you need to use when you try to connect.

Answer 2

Switch from the ClearDB heroku add-on to JawsDB MySQL heroku add-on solve my problem.