TurnKey Linux Virtual Appliance Library

mysql and turnkey drupal [solved]

Hi,

I'm having a problem reconfiguring mysql (or phpmyadmin) to work with a drupal site. It had been a while since I logged into phpmyadmin, and I forgot the password, so I set a new login and password for mysql through the command line (/etc/mysql). Now, for some reason when I go to open the site I get this error: The mysqli error was: Access denied for user 'root'@'localhost' (using password: YES).

There are many threads in other forums about how to fix this in different config files, but I've had no luck adjusting the login info in settings.php, or other various config files. I think part of the problem is I'm not quite sure how drupal is linked to mysql in the turnkey image.

The site was working fine before I changed the mysql login info.

Could someone give me a breakdown on how the turnkey drupal image is setup, and the locations of all the different settings that need to match? Or, is there one place that I can reset the login info so they all match up? Alternatively, how could I simply reset all of the login information for the entire image back to default without losing my drupal settings and database?

I've spent some time exploring the file manager, trying different suggestions, but can't seem to find a fix.

Any help would be greatly appreciated!

 

etech 

mysql password

Allow me to rephrase:

What areas of the turnkey drupal installation are affected by changing the password for the "mysql" database? 

Solved!

Apparently there is a settings.php in /usr/share/drupal6/sites/default. This is where the erroneous login information was entered. I had been trying to work with the settings.php located in /etc/drupal/6/sites/default to no avail.

Just thought I'd update on the issue, in case any other newbies have a similar problem!

 

etech 

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)