jeudi 1 juillet 2021

Cannot connect Laravel to Pgsql - error role "homestead" does not exist

Am a beginner who is trying to connect Laravel with pgsql . I have successfully created a database in pgsql. but when tried php artisan:migrate install , i got the error Access denied for user 'homestead'@'localhost' . Then i tried GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO homestead; in psql, which shown the error role "homestead" does not exist . When browsed the error i could see that if multiple versions of pgsql run simultaneously, this error happens. but i have only one pgsql version running in my system (pgsql -13.3) and i am using Windows os. How to resolve this? Please help me with ur suggestions.

Below given are the relevant lines of my .env file

DB_HOST=localhost
DB_DATABASE=flot
DB_USERNAME=postgres
DB_PASSWORD=abc
DB_CONNECTION=pgsql
DB_PORT=5432


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire