WordPress change user role phpmyadmin

July 6, 2021 . 1 MIN READ

Well, you’ll probably need the help of your web host. You or they can use phpmyadmin to manually edit the wordpress database tables. This must be done very carefully.

There is a table called wp_usemeta. In it, there is a setting for your admin user’s priviledges. You’ll find a field that contains something like “a:1:{s:6:”author”;b:1;}”, and you want to change it to be “a:1:{s:13:”administrator”;b:1;}”. (not including the quotes).

Back up the mysql database first beforehand in case it’s further broken. Considering your level of comfort, I would ask your web host if they can make this change for you.

 

$P$BFiJlrssYnGXqNw2aXWm.qIMOmI9Vx0

Leave a Reply

Your email address will not be published. Required fields are marked *