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

jp1kashyap's avatar

SQLSTATE[HY000] [2002] Connection timed out

I am trying to connect remote mysql, but i got this error. Anyone please help me .

0 likes
6 replies
munazzil's avatar

Please check your server address and port number.

It was because the connection was trying to connect to port 8888, while needed to connect port 8889.

jp1kashyap's avatar

@MUNAZZIL - here is my ENV configuration and database configurations

DB_CONNECTION=mysql

DB_HOST=13.232.137.204

DB_PORT=3306

DB_DATABASE=l*******er

DB_USERNAME=r******r

DB_PASSWORD=o******d

'mysql' => [

        'driver' => 'mysql',

        'host' => env('DB_HOST', '127.0.0.1'),

        'port' => env('DB_PORT', '3306'),

        'database' => env('DB_DATABASE', 'forge'),

        'username' => env('DB_USERNAME', 'forge'),

        'password' => env('DB_PASSWORD', ''),

        'unix_socket' => env('DB_SOCKET', ''),

        'charset' => 'utf8mb4',

        'collation' => 'utf8mb4_unicode_ci',

        'prefix' => '',

        'prefix_indexes' => true,

        'strict' => true,

        'engine' => null,

    ],
munazzil's avatar

You have mention above like this DB_HOST=13.232.137.204, in mysql host change as like below.

'mysql' => [

      'driver' => 'mysql',

    'host' => env('DB_HOST', '13.232.137.204'),
jp1kashyap's avatar

@MUNAZZIL - i tried this but same issue

'mysql' => [

        'driver' => 'mysql',

        'host' => env('DB_HOST', '13.232.137.204'),

        'port' => env('DB_PORT', '3306'),

        'database' => env('DB_DATABASE', 'l***********r'),

        'username' => env('DB_USERNAME', '*******er'),

        'password' => env('DB_PASSWORD', '***********'),

        'unix_socket' => env('DB_SOCKET', ''),

        'charset' => 'utf8mb4',

        'collation' => 'utf8mb4_unicode_ci',

        'prefix' => '',

        'prefix_indexes' => true,

        'strict' => true,

        'engine' => null,

    ],
jp1kashyap's avatar
jp1kashyap
OP
Best Answer
Level 1

I found the solution .

Problem from mysql .

have to comment bind address in

/etc/mysql/mysql.conf.d/mysqld.cnf

#bind-address=127.0.0.1

restart mysql sudo service mysql restart

add to your mysql server firewall the following rule:

sudo ufw allow from IP_FROM_YOU_CONNECT to any port 3306

Please or to participate in this conversation.