CODEWITHSUNDEEP
phpmysqlherokucleardb
Manu Mackwar
Manu Mackwar

Reputation: 61

How to use Mysql commands with ClearDB in Heroku?

I'm using ClearDB with Heroku. I managed to make the migrations that I needed but when I can't find the way to execute queries using the terminal as below:

SELECT * from table .

Thanks in advance.

Upvotes: 4

Views: 2597

Answers (1)

Jason Awbrey
Jason Awbrey

Reputation: 919

Format:

mysql -h host -uuser -ppassword

example:

mysql -h us-cdbr-east.cleardb.com -ubxxxxxx7 -p3xxxxxxx

How to find login info

Use this command in your heroku repo: heroku config

Look for the CLEARDB_DATABASE_URL

Format:

mysql://**user**:**password**@**host**/heroku_db_name?...

Example:

mysql://bxxxxxx7:[email protected]/heroku_xxxxxx?...

After connecting, just USE heroku_db_name and query away!

Upvotes: 9

Related Questions