Announcement

Collapse
No announcement yet.

1227 - Access denied; you need [snip] PROCESS privilege(s)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 1227 - Access denied; you need [snip] PROCESS privilege(s)

    Hello all..

    I am getting an error on a backup I have scheduled because I choose to backup the whole database server and not individual databases.

    I get the following error:
    1227 - Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

    Because it is trying to backup:
    information_schema

    I would rather not choose the databases to backup because I don't want to forget to modify the job when I add or remove a database.

    Anyone know how I can tell it to ignore the information_schema database?

    Thanks in advance!

    --Richie

  • #2
    If you are using the default server backup profile in Batch Job, I am sorry that there is no way to ignore the information_schema database. Your request has been forwarded to our development team. We will keep improving Navicat in future.

    Comment


    • #3
      OK, bummer, but thanks for getting back to me.

      Comment

      Working...
      X