Question

SQLSTATE[HY000] [2002] (trying to connect via (null))

I am using digitalocean managed DB in my laravel app . Everything working fine in tinker mode but when using in app it throws SQLSTATE[HY000] [2002] (trying to connect via (null)) error . even i can connect it from beekeeper studio. here’s my configuration.


Submit an answer
Answer a question...

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev
Site Moderator
Site Moderator badge
December 11, 2022

Hi there,

The error message, trying to connect via (null), indicates that the database host might not be defined correctly, are you deploying your Laravel project to the DigitalOcean App Platform? If this is the case, you need to define your DB_HOST as follows:

  - key: DB_HOST
    value: ${your-db-name.HOSTNAME}

For more information on the available database environment variables, you could take a look at the documentation here:

https://docs.digitalocean.com/products/app-platform/how-to/use-environment-variables/#databases

Here is a quick video that shows how to deploy Laravel to the App Platform:

https://www.digitalocean.com/community/tech-talks/how-to-build-and-deploy-a-laravel-app

Let me know how it goes!

Best,

Bobby