Level 51
Do you have this
DB_HOST = localhost
Aug 17, 2017
8
Level 2
SQLSTATE[HY000] [1044] Access denied
Good day
I uploaded my laravel project to my hosting server for production. However i get the following error,
" QueryException in Connection.php line 647: SQLSTATE[HY000] [1044] Access denied for user 'helpmfap_publish'@'localhost' to database 'helpmfap_publish' (SQL: select * from products)"
i filled my env file correct, where could i be going wrong?
Level 2
Tomi this is what i have
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=help
DB_USERNAME=helpuser
DB_PASSWORD=password
Level 42
Once confirmed the permission for this user into your database. If not granted:
GRANT ALL on help.* to helpuser@localhost;
in MYSQL and replace your correct db name for help and user name for helpuser
Level 51
Did you try with
DB_HOST = localhost
Level 2
@saurabdh where should i put this
"GRANT ALL on help.* to helpuser@localhost; in MYSQL"?
you will have to bear with me.
Level 2
Yes tomi, i did now, i still get the same error.
Level 42
@helpmyworld : This is MySql command, please check this out for more detail.
Level 2
Thank you all, the problem was with my hosting provider. I am using shared hosting, possibly the reason why i am facing challenges.
Please or to participate in this conversation.