We did the setup. When we access the website and this error "500 Internal server error!" pop up and after checking laravel.log the error showing "SQLSTATE[HY000] [1045] Access denied for user ‘softkxnz_ecommerce’@’localhost’ (using password: YES)".
checked the .env file
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=database1
DB_USERNAME='myusername'
DB_PASSWORD='mypass'
and all is ok. Checked many sources on internet say to clear cache when i clear the cache from the go daddy SSH it shows same error. note that ‘softkxnz_ecommerce’ user doesn’t exists. appreciate your support on this.
Tried to change the .env or database.php .. checked many solutions. tried to clear cache php artisan config:clear
2
Answers
Possibly you didn’t give myusername permission to your database database1
Try checking your user permissions
or if your database1 has that user.
The error indicates that your username is softkxnz_ecommerce.
So in the env change the DB_USERNAME to be softkxnz_ecommerce not myusername
hope it helps.
all the best