Locked out of site!! Help
JamesKB - May 15, 2008 - 18:53
I have been building a a site and all of a sudden I am locked out. I get the following error message when I go to http://www.jkbsystems.com
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 'jkbsyste_jameskb'@'localhost' (using password: YES).It had been working just fine until yesterday when I tried to get into the admin area when I received the same error message as above. I have checked with my host and the MySQL server is up and running with no problems.
Any ideas??? HELP! :)
--
James
double check the $db_url &
double check the $db_url & db_prefix lines in your /sites/default/settings.php file
===
"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime." -- Lao Tzu
"God helps those who help themselves." -- Benjamin Franklin
"Search is your best friend." -- Worldfallz
I've checked them.... what
I've checked them.... what should I be looking for?? They look ok to me. I'm not using yes for a password.
Thanks for your time.
--
James
...
So, did your host upgrade the MySQL server recently?
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
No....MySQL server has not
No....MySQL server has not been updated lately. I can get to res.jkbsystems.com (under construction) but not to jkbsystems.com. Strange??
Any ideas??
Thanks for your time.
--
James
could they possibly have
could they possibly have split the mysql server off to a different machine (where it would no longer be "localhost")? I've heard of instances where this has happened.
===
"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime." -- Lao Tzu
"God helps those who help themselves." -- Benjamin Franklin
"Search is your best friend." -- Worldfallz
I'll check that out. But I
I'll check that out. But I don't think they have moved it.
I need some help here. How
I need some help here. How do I get back in to my Drupal site??? I've looked at my settings.php file and don't see anything strange there. I can't tell what "password" it is trying to use since it is encoded.
Should I smiply reinstall Drupal on top of the site with the same DB details?? What?? I need to get into the site.
It is strange. I can get into res.jkbsystems.com but not jkbsystems.com
HELP!! :)
Thanks for your time.
--
James
Command line access?
Can you use putty or gain command line access?
If so, try to access MySQL here using the details, (no space between -p & password XXX)
mysql -u jkbsyste_jameskb -h localhost -pXXX DB_NAME
If that fails, then the DB details are wrong. This is not an issue with the Drupal install. (IE: Don't reinstall)
Re-grant the user permissions to the drupal database, or failing that, create a new user and give them access. This should be fairly easy via phpmyadmin or you web database interface if you have one.
Eg: (replacing password and drupal, the password is not encrypted)
GRANT ALL ON drupal.* TO jkbsyste_jameskb@localhost IDENTIFIED BY 'password';
Alan Davison
www.caignwebs.com.au
Thanks for the reply. I'll
Thanks for the reply. I'll give that a try tomorrow, when I'm fully awake. :)
Thanks for your time.
--
James