virtualMachinewordpress

Reset the WordPress administrator permissions

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;"

Replace the DATABASEHOST placeholder with the host where the database is running.

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 November 4, 2019