Level 73
Normally the host for the database is localhost so check your .env file that DB_HOST=127.0.0.1 is set
Jul 17, 2018
5
Level 1
Error connecting to database after server change
I have recently changed server and uploaded my database to the server, for the live website i made no changes to my env and everything works the same. But in my php storm development i have had to change the ip(db host) and despite the username and password being the same as the live website i am getting an error suggesting i can't access.
SQLSTATE[HY000] [1045] Access denied for user 'connect'@'xxxxxx' (using password: YES)
I have cleared config and cache and tried launching php artisan again but get the same issue. i have even brought in the env from the server(live website) and changed the DB Host to match the IP of the server but then the error occurs. Does anyone know how i fix this error, could it be an issue with the fact the database was imported from another server?
Level 1
Yep that won't work, the website is on the server so and the database is connected fine. This issue is with my development in phpstorm to which im trying to connect to the database host and thats where the issue comes.
Level 122
Your user account on the database server has to be enabled for remote access
Level 1
ITs the same account im using for local access, how do i change it on cpanel to allow remote access aswell?
Level 122
I don't use cpanel, but does this help;
https://www.liquidweb.com/kb/enable-remote-mysql-connections-in-cpanel/
You might need to check with your specific host
Please or to participate in this conversation.