Trying to import my Local database to live site. #1044 - Access denied for user

What issue or error are you experiencing?

Ok so I have now completely lost it.
I built my site on local. I have imported all my files with Filezilla, now trying to import my local database to my live site. I have the export from AdminerEvo. But when I try to import it into mySql I get the error #1044 - Access denied for user. So I tried a bunch of stuff, to be honest don’t really know what I’m doing.

The access denied for user seemed to refer to the local database user, not the database user of my live site. So in AdminerEvo I try a bunch of stuff, I try to create a user that has the same login details as the user on my live site, doesnt work.

I end up somewhere where they say to flush privileges in AdminerEvo for my local database or whatever. So I play around with that, and then my complete database just dissapears from local and it just says Invalid database.

So now I lost my local database, my local website ‘can’t establish connection’ anymore. I have no idea how to get it back. I do have the export, but I can’t import it into my live site cause there I get the error #1044 - Access denied for user

WHAT DO I DO I’m going crazy thinking I lost months of work I put into this website.


What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc


System Details

  • Local Version:

  • Operating System (OS) and OS version:


Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)


Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.


This is what it used to look like in Adminer Evo when creating the export.


This is what it lookes like now


This is the error I get when I try to import my original database export from Local. The database that I now lost somehow.

Ok Ok, I got my local site back… Started a new website and simply copied the files. Now I can access my local site again. But now, how to export this database and upload it to my live site database without this access denied error?


  • DROP DATABASE IF EXISTS local

  • ERROR 1044 (42000) at line 8: Access denied for user ‘nvanbalken’@‘%’ to database ‘local’
  • 2025-05-06 20:39:57,290 [ERROR] ‘mysql’ finished with non-zero exit code: 1
  • Unable to flush stdout: Broken pipe

Hello @nvanbalken! Are you still having trouble here?

If so could you provide some more details to help us take a further look?

  • What is your OS/OS version?

  • What version of Local are you on?

  • Please attach a copy of your Local Logs

Keep us posted and we’d be happy to help further!