Reset the WordPress administrator permissions

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

First, obtain the user ID for the WordPress administrator account from the command line:

$ mysql -u root -p bitnami_wordpress -e "SELECT * FROM wp_users;"

Then, use the command below to reset the administrator permissions from the command line:

$ mysql -u root -p bitnami_wordpress -e "UPDATE wp_usermeta SET meta_value='a:1:{s:13:"administrator";b:1;}' WHERE user_id='ADMIN-ID' LIMIT 1;"

Remember to replace the ADMIN-ID placeholder with the user ID obtained from the first command.

Last modification September 7, 2021