BigDump error: Database connection failed due to access denied for user…."

  • If someone can help me with this I’d certainly appreciate it.

    I’m trying to move a WAMP localhost wordpress installation from my desktop to my laptop using bigdump to import the database file.

    I downloaded and unzipped bigdump on the laptop.
    Put the bigdump folder in the localhost/wordpress folder on the laptop and then put the bigdump.php file in it.
    Exported the database sql file from the desktop to a thumb drive.
    Placed the database sql file in the bigdump folder on the laptop.
    Started WAMP on the laptop and started all services.
    Created a new database with the same name as the one on the desktop.
    Opened the bigdump.php file in the bigdump folder on the laptop.
    Opened the wp-config file in the wordpress folder on the laptop.
    Copied the host name, username, password, and database name from the wp-config.php file in wordpress on the laptop into the bigdump.php file on the laptop.
    Opened phpMyAdmin on the laptop and copied the path to the bigdump.php file on the laptop into the browser.
    Hit ENTER and got this error message:

    Database connection failed due to Access denied for user (‘root’@’localhost’ (using password: yes).

    I simply can’t make it work, and I can’t find a solution on the Web.
    I’ve checked the settings in the bigdump.php file closely. They are right out of the wp-config.php file in the wordpress directory.

    Any help here would be greatly appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi,
    Is WordPress installed and running on the laptop?

    The only thing I can think of is that your username and password in the wp-config is from your desktop and the username and password on the laptop are different. I did read that you confirmed the username was the same, but I would double check the MySQL database password on the laptop.

    Side note: Typically the root user has all privileges on a database, but you might want to double check those too, just to make sure root can access and perform all functions on your new database on your laptop.

    I’ve used bigdump often and it typically either the credentials or user privileges, so hopefully it’s that simple for you and you can get your data imported!

    Thread Starter adhdcelt

    (@adhdcelt)

    Thanks, Brandon.
    I appreciate your insights.

    Yes, wordpress is on the laptop. I “copied” it from the desktop to the laptop. When I try to run the site in a browser via https://localhost/wordpress, I get the error message: “Error Establishing a Database Connection.

    And yes, username, password, host, database name, etc. are exact matches in both the desktop and the laptop wp-config.php files.

    As for privileges, I assume I go into WAMP phpMyAdmin, select the database, select privileges, and check the settings for each user using Edit Privileges. I did that for all users, and everything under Administration is checked “yes.”

    However, when I look at “databases” in the left column of phpMyAdmin, I see six databases listed, the one I’m trying to work with, another one I created for another site at an earlier time ( I renamed this folder to “wordpress.hold so it would not interfere with the one I’m working with), and four more: information_schema, mysql, performance_schema, and “test.”

    This has to be pilot error, but I can’t see it.

    I’m happy to help, I just wish I could have said something that would have gotten this going for you.

    It sounds like you know your way around phpMyAdmin. You were looking in the correct place. And connecting through localhost shouldn’t be an issue either. If you’re able to use phpMyAdmin, then obviously your server is running and allowing connections via localhost.

    The only thing I know to do is to double check for typos, reset the laptop’s database user to the password that it’s supposed to be and once more make sure the user is given access to the database in the database>Privileges tab and has all privileges.

    Side note: On MAMP you can change port numbers, but it doesn’t really affect anything. MAMP seems to handle it all on its own. However, I’m not sure if WAMP plays along as nicely. Might be worth double checking as well.

    If that doesn’t do the trick, then I’ll cross my fingers for someone smarter than me to come along. ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘BigDump error: Database connection failed due to access denied for user…."’ is closed to new replies.