mysql connection with server(cpanel) error

Question

Warning: mysqli::__construct(): (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

try{   
    $mysqli = new mysqli('cpanelhost','cpanel_db_user','cpanel_db_password','cpanel_db','port');
    if ($mysqli -> connect_errno) { 
        echo "Failed to connect to MySQL: " . $mysqli ->connect_error;
        exit();      
    } 
    $sql = "INSERT INTO table (column1, column2) VALUES ('value1', 'value2')";                    
    $mysqli->query($sql) ;      
    $mysqli->close();
}
catch(Exception $e){
    $mysqli->close();
    return $e;  
}

user18203664 · Accepted Answer · 2022-09-27 12:57:24Z

1

I would highly recommend you to:

Ask your hosting provider if they ALLOW remote MySQL connections.
Ask your host if port 3306 is open.

If the above is covered, then you will need to:

Add the IP address of the remote machine ( where you are trying to establish this connection ) to "Remote MySQL" in cPanel.
Use your server's hostname or IP as the MySQL Host in your connection configuration.

And if you still cannot establish a successful connection, I would recommend switching to a managed hosting provider which fully supports remote MySQL connections.

answered Sep 27, 2022 at 12:57

user18203664

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql connection with server(cpanel) error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related