Level 1
Double check the credentials you are providing.
PHP tries to establish a connection with MySQL end on the server but there is no response.
Apr 25, 2022
17
Level 1
Laravel connection timed out
I've searched a loot on google about this problem and I tried everything. I have a database of a game from a hosting and I bought another webhost (shared hosting) from another company.
I have Laravel 7 on my website and I want to display all users informations from database and many other things.
The problem that i'm facing, is that, I need to access the database remote OUT (which I spoke with the support of the shared hosting and they said that they allow it), but still I get this error:
[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection timed out at /home/kirosne1/web/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70)
The page is render (for example: login page) but when I click the 'login button' to check if the user exist, I wait for aboout 30 seconds and it gets me error 404 and in laravel.log is the above error.
My .env is something like this: (example - not the real credentials):
DB_CONNECTION=mysql
DB_HOST=195.205.39.83
DB_PORT=3306
DB_DATABASE=hji2jsad232
DB_USERNAME=hji2jsad232
DB_PASSWORD=23sadsadsa
I tried to connect from a local mysql on the shared hosting i bought, and is working, but remote OUT is not.
I tried changing the php version from cpanel, also to clear the config cache and it didn't work.
What should I do?
Level 1
@underdash Well, I did that, even 3 times, and still not working.
Level 1
@Rayan Do you have any sort of Database Management tools ?
If you do not have one install one, then try to make a successful connection with the tool first then replace credentials in your .env file.
Level 1
@underdash Sorry, I don't really know what you mean, can you give me an example?
Level 1
Level 1
@underdash Yes, is working on TablePlus, I have connected successfully.
Level 51
I don't believe your database host opened it for remote access. Check again with them.
And please don't share any credentials, it's unsafe.
Level 1
@MohamedTammam I've check multiple times, even today, and they said is everything ok
Level 54
This is unlikely allowed by the hosting provider. perhaps use the same server or provider may be the better choice.
Level 1
Since connection is being established using database management tool. Try replace a domain with a TLD instead of an ip address for your DB_HOST.
Something like:
DB_HOST=mysite.org
Level 1
@underdash i tried, still no results..
Level 39
What the value of the connection timeout of your remote db?
SHOW VARIABLES LIKE 'connect_timeout';
Try to increase this parameter
SET GLOBAL connect_timeout = ...
Level 1
@sr57 the value is '10' and I don't have access to change it
Level 39
What (any error if does not work) if your try this command
DB::statement("SET GLOBAL connect_timeout = 100");
or
DB::statement("SET connect_timeout = 100");
Level 1
@sr57 #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Level 39
Can you check these 2 variables interactive_timeout & wait_timeout, if not set to 28800, change them to this value and test again.
But probably you seem to get a poor database connection, if you cannot change connect_timeout, you should consider to change.
Level 1
What is your environment settings ? Is it a shared host ? Self-configured VPS ? or a Cloud ? Are you using docker ?
There are numerous scenarios please provide more information.
Please or to participate in this conversation.