By vickijd on

After successfully setting up a dupal site on my local machine I am now trying to install drupal on a live site. I have changed this line in settings.php:

$db_url = 'mysql://myusername:mypassword@lon1-webmysql-3.msh.demon.net/mydatabasename';

where myusername, mypassword and mydatabasename have the correct values, and I am getting an "Unable to connect to database server" message. If I put in the IP address of the server instead, I just get the white screen of death.

Any ideas anyone?

⋅ Categories: Drupal 5.x

Comments

vickijd’s picture

vickijd commented

Okay, I reset the settings.php file and then used the advanced options button on install so I have got a bit closer now. I'm now getting the problem of being unable to lock a test table.

tm’s picture

tm commented

you may wish to verify that your dbuser has all the required rights:

SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES

good luck!