error 1044 when importing an sql file to a new database

  • nick1900

    (@nick1900)


    12 years, 2 months 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)

    12 years, 2 months ago

    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)

    12 years, 2 months ago

    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)

    12 years, 2 months ago

    see if info in this thread helps: http://wordpress.org/support/topic/switching-serversimporting-database-issues?replies=5

    Thread Starter nick1900

    (@nick1900)

    12 years, 2 months ago

    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)

    12 years, 2 months ago

    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)

    12 years, 2 months ago

    I also encountered this error

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

    catacaustic

    (@catacaustic)

    12 years, 2 months ago

    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.