#1044 – Access denied..database information schema?

  • Xenoshane

    (@xenoshane)


    11 years, 7 months ago

    While trying to restore a backup in myphp ive encountered a problem..

    Now i know what youre thinking- yes its the correct account, yes ive the privileges enables.

    ive also tried to create a new db and user and fill that in with a backup.

    anyone have something simialr before?

Viewing 1 replies (of 1 total)
  • s_ha_dum

    (@apljdi)

    11 years, 6 months ago

    You didn’t provide a lot of detail but this is what it sounds like to me.

    You dumped the information_schema table along with everything else. That table is used internally by MySQL and you should never really mess with it. When you try to restore the backup, you are attempting to write to/overwrite the information_schema table, which is wrong.

    You will probably have to edit out the information_schema queries from your backup.

Viewing 1 replies (of 1 total)
  • The topic ‘#1044 – Access denied..database information schema?’ is closed to new replies.