Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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?
Comments
The connection string is
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
Yes but supposed i want password = xxx, what do I have to make the line look like :
$db_url = 'mysql://username:xxx/databasename';
?
see settings.php
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.
Hello, What's the difference
Hello,
What's the difference between mysql and mysqli as given in commentaries?
By default my installation uses mysqli.
Thanks
difference between mysql and mysqli
> 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
I have the same problem
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? ....."