Error when Importing a MySQL Database -“1044 – Access Denied”

If you have ever tried to move a website, and more specifically your MySQL database, you may have seen this error before. These can be frustrating and time-consuming. Here is a quick fix though!

  1. Make a backup copy of the SQL file you want to import.
  2. Open the SQL file with a text editor, such as Notepad++, Sublime, or your favorite editor.
  3. Search for strings that are CREATE DATABASE %Database name% or USE %Database name%%DatabaseName% is a placeholder for the actual database name in your SQL file.
  4. Delete these commands. Be careful not to inadvertently remove other statements.
  5. Save your changes.

This should get you back on track quickly so you can get your site running smoothly again.

Like this article?

Share on facebook
Share on Facebook
Share on twitter
Share on Twitter
Share on linkedin
Share on Linkdin
Share on pinterest
Share on Pinterest

Leave a comment