Level 51
Try to change DB_HOST to
DB_HOST=localhost
Oct 25, 2017
8
Level 9
SQLSTATE[HY000] [1045] Access denied for user
I uploaded laravel 5.5 to the server and updated the .env file with the database credentials but anytime the app tries to make connection with the database i get Access denied for user. Note: i can login to PhpMyAdmin using the same credentials. my env looks like this:
DB_CONNECTION=mysql
DB_HOST=mysql5019.smarterasp.net
DB_PORT=3306
DB_DATABASE=db_a2bab9_blubuk
DB_USERNAME=db_a2bab9_blubuk
DB_PASSWORD=db_password
Error message:
SQLSTATE[HY000] [1045] Access denied for user 'db_a2bab9_blubuk'@'10.10.28.214' (using password: YES) (SQL: select * from `users` where `username` = ntagoe limit 1)```
Level 9
@tomopongrac when the DB_HOST is changed to localhost the connection is refused by the server
SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. (SQL: select * from `users` where `username` = ntagoe limit 1)
Level 10
First check your password then try DB_HOST=localhost or DB_HOST=yourdomain.com or DB_HOST=Server IP
Level 9
@RamjithAp i can login to phpmyadmin using the same credentials. i have tried all that but anything other than this DB_HOST=mysql5019.smarterasp.net throws this error SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. (SQL: select * from `users` where `username` = ntagoe limit 1)
Level 10
Did you checked the db user db_a2bab9_blubuk is assigned to db_a2bab9_blubuk properly if not go to your cpanel->databases and assign. Try resetting the password once and try. Laravel has nothing to do with this issue try this solution https://stackoverflow.com/questions/31154124/sqlstatehy000-1045-access-denied-for-user-usernamelocalhost-using-cakep
Level 1
Just use quotation its work for me
DB_HOST='xxxxxxx' DB_USER='xxxxxxx' DB_PASS='xxxxxxxx'
1 like
Level 1
@nandlal-tjm awesome, this solved the it
Level 3
Thanks man @nandlal-tjm . it also works for me.
Please or to participate in this conversation.