error 1044 when importing an sql file to a new database

  • nick1900

    (@nick1900)


    11 years ago

    I haven’t found a conclusive answer to this anywhere although the problem seems common:

    I had an issue with an sql database (it was deleted) but I have a database backup file created by a plugin. So I installed a new version of WP, restored the wp-content folder and thought it was a simple process of importing this file into the phpmyadmin. However I get the error: ????Error in query (1044): Access denied for user ‘dbo516153407’@’%’ to database ‘lechiron’

    Where do I make the change so that all tables are re-imported correctly into the database? The hosting is with 1&1, I tried with the Adminer plugin but it returns the same error.

    I’ve never had this issue before and it’s proving hard to fix, thanks for any help.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator t-p

    (@t-p)

    but I have a database backup file created by a plugin.

    From what WP version?

    Be aware that the database ( DB ) structure often changes between versions. The implication is that, for example, one cannot import a pre 3x database into a 3x install and expect it to work.

    Thread Starter nick1900

    (@nick1900)

    It is from 3.x to 3.x, the error is specific to the import and something to do with users, not versions

    Moderator t-p

    (@t-p)

    see if info in this thread helps: https://www.ads-software.com/support/topic/switching-serversimporting-database-issues?replies=5

    Thread Starter nick1900

    (@nick1900)

    actually I saw that thread when I was searching and it’s not quite the same as I don’t have a Create database line in the file

    catacaustic

    (@catacaustic)

    This error:

    Error in query (1044): Access denied for user 'dbo516153407'@'%' to database 'lechiron'

    That tells you what’s wrong. Your DB user doesn’t have the required permissions over your database. That means that the user isn’t allowed to do what you’re asking it to.

    This is a hosting issue, and something that you need to change through your hosting control panel. If you can’t figure that out you’d be best off asking your hosting company as they can sort this out for you.

    khoaplus

    (@khoaplus)

    I also encountered this error

    this is my Blog https://myreviewbonuses.com/

    catacaustic

    (@catacaustic)

    You obviously got it fixed… care to share how you did it??

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘error 1044 when importing an sql file to a new database’ is closed to new replies.