How to change WordPress user roles in PhpMyAdmin (MySQL Database)?

  Web Hosting

You can change the WordPress user roles by following the given steps:

Step 1: Open phpMyAdmin on cPanel.

Step 2: Open the wp_usermeta or xxx_usermeta table in the database as highlighted. (wp_ is just prefix, your table prefix may be different)

Step 3: In wp_usermeta table, you can find wp_capabilities under meta_key column.

Step 4: The roles are saved in form of serialized PHP array. Change the user role you want to assign to the current user by changing the meta_value as:

Subscriber
a:1:{s:10:"subscriber";b:1;}
Contributor
a:1:{s:11:"contributor";b:1;}
Author
a:1:{s:6:"author";b:1;}
Editor
a:1:{s:6:"editor";b:1;}
Administrator
a:1:{s:13:"administrator";b:1;}