How do you change the database username and password for a drupal site. I developed a site on my localhost and registered the database username as rot with no password. I would like to upload this site tyo a live server but the live server is not going to allow my site to log in to the database as root with no password. How do I change these settings? Also someone else developed a drupal site for me on his machine and gave the database username and passowrd something. I now would like to run and test the site on my own machine but it says failed to connect to name@localhost using password yes. How do I change those details so that I can load the site on my own machine and test it. How does on move a drupal site to a live server and change the login details for the site?

Comments

arif_mandra’s picture

arif_mandra commented

Hi,

Change your live server database details in settings.php. You can find settings.php at following location:

/sites/default/setting.php

Change following line :

//$db_url = 'mysql://username:password@localhost/databasename'

to

$db_url = 'mysql://:/@l//

It might be possible the entry is already there for your local host details, update with your live server database details.

Let me know if you still unable to achieve this.

Thanks & Regards,

Arif

arif_mandra’s picture

arif_mandra commented

Hi,

Sorry last post has crop some of data.

The change you can do is :

$db_url = 'mysql://username:password@localhost/databasename'

updated with your live server database details.

dpearcefl’s picture

dpearcefl commented
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

Does #2 resolve your issue?

dpearcefl’s picture

dpearcefl commented
Status: Postponed (maintainer needs more info) » Active
vip_sa’s picture

vip_sa commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.