Home / server / Questions / 231825
Accepted
April
Asked: 2011-02-07 03:40:38 +0800 CST

DRupal and mysql with a remote database

  • 772

Trying to connect Drupal running from my localhost to a remote database but coming across issues.

I am using the following string in my settings.php file:

$db_url = 'mysqli://username:[email protected]/database_name';

I am getting the following error:

Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\myapp\includes\database.mysqli.inc on line 115

What I am doing wrong?

mysql drupal

2 Answers

  1. Best Answer

    Check connection to remote database:

    $ telnet xx.xx.xx.xx 3306

    or 

    $ mysql -u username -p -h xx.xx.xx.xx -D database_name

    On remove server can be configured firewall or MySQL not listen to xx.xx.xx.xx address.

    • 2

  2. Increase the max execution time in your php.ini to see if this helps.

    • 0