My Drupal site disappeared when I reset the root password of MySQL!
I am new to drupal. I intended to instal a drupal main site and multiple test sites in my uniserver installed on my PC. Following the installation instruction regarding multiple sites. I installed a drupal 6.12 main site following the instruction to configure it with a no password access to mySQL.
I succeeded in successfully installing and saving this without further action on the main site. In trying to install the test sites I tried to access the test sites databases via phpmyadmin only to discover that I can no longer access mysql because of Error #1045 Access denial.
I order to gain access to mySQL via phpmyadmin, I had to reset mySQL username and password to root:root. Once I succeeded in gaining access to my phpmyadmin, I now discovered I could no longer access the site I configured through localhost. I now tried to reinstal the site, I was told that drupal is already installed in my system, and got the following Error message:
''Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'root'@'localhost' (using password: NO).
Are you sure you have the correct username and password?
Are you sure that you have typed the correct database hostname?
Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider''
What can I do to get this site online again on my localhost? I am desperate because I have been going through this cycle of installing, uninstalling and re-installing for weeks now. I am so frustrated. I know drupal is good but there are things I am missing.
Can anyone come to my rescue and tell me what i am doing wrong.
[Heine - changed ALL CAPS title]
Set you new password in the settings.php file
which is located at 'sites/default/settings.php'
Set line 93 (or somewhere around that number, before "Base URL" part) to
$db_url = 'mysql://root:root@localhost/NAME_OF_DRUPAL_DB';
Look under sites/defaults
Look under sites/defaults for settings.php. Make sure the file is writable, edit the file and look for the line that looks like
$db_url = 'mysql://login:password@localhost/database_name';From your notes, password is probably blank, you will need to change login and password to valid values (probably root/root from what you said).
I have done as Instructed
I followed through the instruction by changing mysql username:password to root:root. With this, I can now access phpmyadmin but my drupal site is still showing as Offline with the following message:
" Site off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.
If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.
The mysqli error was: Access denied for user 'root'@'localhost' (using password: NO)."
So what do I do next so that the site can now come online. And then what the next step to create multiple test sites out of the main configuration?
I think I got into this mess following the instruction to Configure the main drupal site with "No Password" to enable me create the multiple sites. Am itching to know what i have done wrong.
To Own Your Life, Click this link: http://tiny.cc/oyf