Drupal 6 The Mysql Error Was Access Denied For User
all over the world. Join today Community Community Home Getting Involved Chat Forum SupportPost installation The mysqli error was: Access denied for user drupal access denied for user 'root'@'localhost' Posted by Upstream on February 1, 2010 at 5:12pm Hi, I am sqlstate 28000 1045 access denied for user a fairly new user of Drupal. Yesterday my database host required I change the password for the database. Now I get the following error message on my drupal website:The mysqli error was: Access denied for user 'db_username'@'database.address.no' (using password: YES). I have changed the password for the database in site/default/settings.php without that changing anything. I am confident my password is correct as I have no problem logging onto phpmyadmin. The new password does contain some special characters (though not quotes or apostrophe). I did experiment with escaping a special character without that changing anything either. Is there someone out there with more experience and can give me a hint of other things to try to get my site back up and running? Thanks for any help! Log in or register to post comments ⋅ Categories: Drupal 6.x Comments Update... Upstream commented February 1, 2010 at 8:57pm After a lot of testing, I decided to change my password slightly. I had used a plus-sign as part of the password for my database. When removing the '+' in the password, and changing my settings.php accordingly, it all worked. I know from both the command line interface for mysql, as well as phpmyadmin, that the password with the '+' was accepted there. I have not found anywhere that a '+' needs to be escaped in a php-string. So, not sure what caused the '+'-containing password to mess things up - but happy to see it working. If anyone knows why the '+' in a password did not work I am curious to hear from you! Log in or register to post comments Had a similar issue centralh2o commented May 19, 2010 at 5:37pm I had a
all over the world. Join today Community Community Home Getting Involved Chat Forum SupportPost installation The MySQL error was: Access denied for user: 'root@localhost' (Using password: YES). Posted by mrfrazzlebottom on August 9, 2006 at 12:42am I recently received this error message: Unable to connect to database server This either means that the username and password information in your settings.php file is incorrect or we can't contact the MySQL database server. This could mean your hosting provider's database https://www.drupal.org/node/701462 server is down. The MySQL error was: Access denied for user: 'root@localhost' (Using password: YES). Currently, the username is root and the database server is localhost. ... Here is why I posted in Post Installation: This error happened some weeks after I had installed and had a successfull go of it. I had added lots of content, https://www.drupal.org/node/77743 etc. This error suddenly appeared without warning one day when I went to the site, and where a few days before it was working. In the beginning, I had used cPanel/Fantastico to install Drupal, and it went well. Who can say what went wrong? (I had just before this failure, used cPanel/Fantastico to install another software package. Perhaps that caused the problem?) Beats me, and I am sure everybody else. Just how could an error like this happen? I could use phpMySqlAdmin to access the Drupal database, and it gave no indication of a problem. I actually even exported the database, downloaded the Drupal installation and installed it on my home PC, where I used phpMySqlAdmin to import the database. I then modified the lcoal settings.php file for the local MySql user/password and I have the old online site fully back in operation locally. I even just used cPanel/Fantastico to install a second copy of Drupal on my website, in another directory, it it too works fine. But there
you come to know about us - None -Google SearchOther SearchFrom A FriendFrom A WebsiteFacebookOther Social Media What is http://www.zyxware.com/articles/4574/drupal-how-to-solve-mysql-erroraccess-denied-for-user-userlocalhost-even-if-the-password-is-correct-in-drupal-6 your budget custom requirements To prevent automated spam submissions leave this field empty. You are hereHome » Articles » [Drupal] How to solve MySQL error"Access denied for user 'user'@'localhost' even if the password is correct in Drupal 6 [Drupal] How to solve MySQL error"Access denied for user 'user'@'localhost' even if the password is correct in Drupal 6 By: Arjun S Tweet March access denied 19, 2015 - 09:59 0 Comments Drupal 6 There are some constraints when giving passwords for mysql databases when using with drupal 6. Some special characters will make the site unavailable with the error "Access denied for user 'user'@'localhost' (using password: YES)" even if the password is correct in Drupal 6. This issue may also be caused by some other reasons too, access denied for however the following problem is a major one causing the issue. All the problems started after changing the MySQL user password associated with the mysql database.After that the drupal 6 site is unavailable showing the error "Access denied for user 'user'@'localhost' (using password: YES)" and it is clear that the password provided is correct. After changing the password, i have explicitly changed the password in the settings.php file.By analysing it is found that some special characters in the password may be the culprit. By replacing the special charecters with some others found the actual culprit. It is the "+" sign in the password that is making the problem. The actual problem is with the way drupal 6 parses the db url which is in the format "mysql://username:password@localhost/databasename". Drupal 6 uses the default php function parse_url(). The problem with parse url is that any of the special characters :, /, @, +, (, ), ?, =, and & will result in an unexpected behaviour of the function, which is causing the error even if the password was correct. Inorder to avoid the problem we c