Siteground + Sucuri Issues with DB Permissions?

  • Hey Peter. Finally got around to following the instructions in the link you sent for setting up Hide my WP Ghost and all seemed fine until today when i got a sql error as follows

    mysqldump: Got error: 1044: “Access denied for user ‘duz6btht_wp50929’@’localhost’ to database ‘duz6btht_wp50929′” when using LOCK TABLES

    I assume this has to do with permission for the user of the database but i did follow the permissions in the link you sent.

    Also this seems to be a sucuri cron SQL dump, im assuming to backup the database which is a daily thing.

    Should i enable one of the permissions the link told me to disable for the database to allow this daily dump/backup?

    Any idea’s?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Peter

    (@petersquirrly)

    Hi @garmatinc,

    This is more related to the permissions in the database rather than Hide My WP Ghost.

    Please activate the Lock Table permission that is needed. You can do it through PHPMyAdmin or server panel.

    Thread Starter garmatinc

    (@garmatinc)

    Hey Peter, thanks for the reply.

    The issue started happening right after we had Hide my WP Ghost all setup and has happened every day since when it tries to backup the DB.

    I notice this article
    https://michaelrigart.be/mysqldump-1044-access-denied-using-lock-tables/

    I decided to create another user for the database and changed the backup cron to include this new user instead of the other one and then gave full access to this new user.

    Will see what happens, does this sound like the correct way to do this?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Siteground + Sucuri Issues with DB Permissions?’ is closed to new replies.