Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By rpk on
Hi,
After having successfully migrated several Drupal 6 sites from my local development server (WAMP) to my online server, I have a case here were I just can't migrate a site from the web server back to my local machine.
The error I'm currently getting is: "The mysql error was: Access denied for user 'DATABASENAME'@'localhost' (using password: YES)." (I replaced the actual all lower case database name with DATABASENAME in this example.)
I already tried everything I can think of and really need help!
I tried all kinds of things with the local database, incl. changing/adding/deleting passwords, changing database name, changing user name and privileges etc.
At this point I have run out of ideas and would appreciate help!
Note that the web server database has a 7-2 at the end of its name. However, when I tried to import the database I repeatedly get an error message that line two "Use DATABASENAME7-2" causes an error, as "-2" is not valid. So before importing I changed the database name in line 1 (CREATE DATABASE) and line 2 (USE) to DATABASENAME7.
I'm not sure if this might have something to do with the problem.
Thanks,
RPK
Comments
Did you change $db_url in
Did you change $db_url in settings.php to reflect the new database name?
Yes, I changed settings.php
Yes, I changed settings.php to reflect the name change.
I guess one question that came up working on the migration of this site is that the original database didn't have a password, just a name and username 'root', but I left password empty. After importing the database on my local machine I made sure that privileges are all enabled (no restrictions) and that the database itself has no password. I have no idea why the error message indicates there is a password.
Thanks for your reply!
RPK
Are you trying to pass it a
Are you trying to pass it a password?
$db_url = 'mysql://user:PASSWORD@localhost/database';I guess, yes, I am. I
I guess, yes, I am. I compared with my original settings.php, as well as settings.php from another Drupal site currently working on my local machine and both pass a password even though the database shouldn't need it. If I need to not pass a password, how would the $db_url have to look like?
Thanks for your help!
RPK
Got it working by taking out
Got it working by taking out the password in settings.php as suggested!
Thanks so much for your help!! Highly appreciated!
RPK
Glad you got it figured out!
Glad you got it figured out!
404 error while trying to log in
After following the procedures, I could transfer the database and file from web to desktop XAMPP server. Site looks as it should be, but it gives a 404 error when i try to log in as admin.
Would appreciate any help in this regard.
Did you transfer the
Did you transfer the .htaccess file from the root drupal directory?