By sahuni on

Bonjour,
When we install Drupal, we give the name of database, user and password. I supposed it's stored somewhere.
How can we change the password of mysql connexion?
Now, I can't access my local drupal installation because, during installation I specified no password, and after easyphp upgrade, I get a new password.
Now, Drupal send the page :
Site off-line
The site is currently not available due to technical problems. Please try again later ...
The mysql error was: . and nothing
How can I continue to work with that Drupal installation?

⋅ Categories: Drupal 6.x

Comments

lemmax’s picture

lemmax commented

The connection string is stored in this file:

sites/default/settings.php

Specifically, look for the line:

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

You can edit the file using a plain text editor.

sahuni’s picture

sahuni commented

Yes but supposed i want password = xxx, what do I have to make the line look like :
$db_url = 'mysql://username:xxx/databasename';
?

jpoesen’s picture

jpoesen commented

No, follow the example given by lemmax:

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

so in your case that would be :

$db_url = 'mysql://username:xxx@localhost/databasename';

Have a good look at the settings.php file - there are about 50 lines of help text in there that describe how to construct the database connection string.

TrainingCloud.io - Drupal Training with a Heart.

humanoc’s picture

humanoc commented

Hello,

What's the difference between mysql and mysqli as given in commentaries?
By default my installation uses mysqli.

 * Database URL format:
 *   $db_url = 'mysql://username:password@localhost/databasename';
 *   $db_url = 'mysqli://username:password@localhost/databasename';
 *   $db_url = 'pgsql://username:password@localhost/databasename';

Thanks

asb’s picture

asb commented

> What's the difference between mysql and mysqli as given in commentaries?

mysqli is a newer and imho faster implementation of the MySQL database connector. Sometimes Drupal's installer uses mysql, sometimes mysqli; judging from my own installations I assume that D6 prefers mysqli while D5 usually set up mysql - but I'd be interested in a more knowledgable opinion, also ;)

Greetings, -asb

cellcomputer’s picture

cellcomputer commented

Hi

I have the same problem

My local machine database information are username: root and no password and my database name is : database

My host sql; infromation are:

Prefix: life with sql password different to my database password
my database name is database
my database username: admin
password is admin

and I have set my configuration like:

$db_url = 'mysqli://admin:admin@94.195.72.11/database';
$db_prefix = '';

I still have pronlem with my site off-line

What can I do to have a corect setting

Yours sincerely

Vincent

"When we install Drupal, we give the name of database, user and password. I supposed it's stored somewhere.
How can we change the password of mysql connexion?
Now, I can't access my local drupal installation because, during installation I specified no password, and after easyphp upgrade, I get a new password.
Now, Drupal send the page :
Site off-line
The site is currently not available due to technical problems. Please try again later ...
The mysql error was: . and nothing
How can I continue to work with that Drupal installation? ....."