'How do i create and manage my database for online website?
I imported my Symfony project on heroku to see how it will be on production. But i got this error:
2022-03-18T13:30:30.230251+00:00 app[web.1]: [18-Mar-2022 13:30:30 UTC] [critical] Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused" at /app/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 103 2022-03-18T13:30:30.230298+00:00 app[web.1]
So it means that they can not connect to my database, it seems normal since the DATABASE_URL in the .env file is for the localhost(phpmyadmin, root, pwd ="", etc). I have seen that we can add add-ons and i tried to add one for database(ClearDB) but they asked for Credit card(but my one is not available now). I am now looking for a database manager so that i can create my database, get the database's parameters(username, password, etc.) and add it to the heroku app so that i can do my migrations and launch the wesbite. Is this possible, with which software ?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|