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?

Comments

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.

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

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.

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

> 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

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? ....."

vincent