To change a hosted site’s automatic user to the Administrator role:
- Go to Hosting Services > Credentials in your 10Web dashboard
- Click Open MySQL in the Database Access section
- Log in to the website database with the Database Access credentials from the Hosting Services > Credentials section
- Click on the wp-option > wp-users table and find out the user ID.
- Go to wp-usermeta > Edit on the corresponding user with the ID from step 4.
- In the meta key field enter wp_capabilities.
- In the meta value field enter the corresponding value from the list below. For the Administrator role, it should be a:1:{s:13:"administrator";b:1;}
For other user roles, see the following values:
- Administrator: a:1:{s:13:"administrator";b:1;}
- Editor: a:1:{s:6:"editor";b:1;}
- Author: a:1:{s:6:"author";b:1;}
- Subscriber: a:1:{s:10:"subscriber";b:1;}