Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

cyntechtic's avatar

Database error

Please I get the above error when I try to login to my user account on my web server but on localhost it is working perfectly

PDOException in PDOConnection.php line 43: SQLSTATE[42000] [1044] Access denied for user 'frin_apps'@'localhost' to database 'frin_apps'

QueryException in Connection.php line 647: SQLSTATE[42000] [1044] Access denied for user 'frin_apps'@'localhost' to database 'frin_apps' (SQL: select * from users where email = [email protected] limit 1)

0 likes
8 replies
phpMick's avatar

Looks like frin_apps does not have permission set on your database.

Try logging in using your favourite SQL editor.

Mick

1 like
marcoax's avatar

check your db configuration in .env file

cyntechtic's avatar

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=frin_apps DB_USERNAME=frin_apps DB_PASSWORD=password

and I have the above user with the necessary permissions

Ltloafer's avatar

You will need to change these settings in your .env file for Godaddy, and you'll need to get them from them. Personally, I would consider using Forge as it makes it easy to change your settings for your production environment.

cyntechtic's avatar

Thanks all for your review and assistance I noticed the the database user permission was not granted.

Meanwhile I did set up my Laravel project too to a virtual private server (VPS) using the LEMP stack but there is something common to my project on both godaddy and Vultr server, I noticed two of the links keeps loading and fails with error (This page isn’t working 45.32.147.114 didn’t send any data. ERR_EMPTY_RESPONSE.)

Please do follow the link below where I am carrying out my test, and see with your experience how I can resolve this issue because on my local system server=> Windows&Xampp it works perfectly.

  1. 45.32.147.114

  2. Click on register and create a dummy user and it will log you in.

  3. And you will find the four links below

i Create Profile (New User)/ ii Profile ----------(Doesnt work)/ iii Create Skill Profile (New User)----------(Doesnt work)/ iv Skills

Note : it works perfectly on my localhost

Please or to participate in this conversation.