How to revert index key, I can’t change any field in my database

  • Resolved locha9066

    (@locha9066)


    1 year, 6 months ago

    Hi, I forgot backup my database before.

    Currently, I can’t access to /wp-admin/plugins page, all plugin not working. I was try change in “wp_option” and active in “active_plugins” (option_name column). But not work.

    I try install WP-CLI to try disable ( I install WP-CLI success in my VPS but when I try run: wp help index-mysql show this error:

    wp help index-mysql
Error: YIKES! It looks like you're running this as root. You probably meant to run this as the user that your WordPress installation exists under.

If you REALLY mean to run this as root, we won't stop you, but just bear in mind that any code on this site will then have full control of your server, making it quite DANGEROUS.

If you'd like to continue as root, please run this again, adding this flag:  --allow-root

If you'd like to run it as the user that this site is under, you can run the following to become the respective user:

    sudo -u USER -i -- wp <command>

    I can run the command wp --info like this image:

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter locha9066

    (@locha9066)

    I fixed this problem.

    Plugin Author OllieJones

    (@olliejones)

    Glad to hear you fixed it. For the benefit of others with similar problems, please (if you have time) explain how you fixed it.

    And I use sudo -u www-data wp index-mysql status and similar commands to run wpcli as the same user as the web server. This avoids changing file permissions so the web server can’t use files.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to revert index key, I can’t change any field in my database’ is closed to new replies.