<div>
thanks for the explanation. I found the admin user, but I will still create my own as well.<br />
<br />
I inserted the new row in wp_users, now trying to insert rows into wp_usermeta. I don't see an option or where to insert &nbsp;the wp_capabilities key or wp_user_level.
</div>


thanks for the explanation. I found the admin user, but I will still create my own as well.

I inserted the new row in wp_users, now trying to insert rows into wp_usermeta. I don't see an option or where to insert  the wp_capabilities key or wp_user_level.

<div>
If you are using PHPmyadmin then you are inserting into the user ID, key, and value columns. Wp_capabilities is the actual text you are inserting.<br />
<br />
The user ID is the user ID. &nbsp;The key is wp_capabilities, the value is that string from my original post.<br />
<br />
Then repeat with user ID, wp_user_level, and 10
</div>


If you are using PHPmyadmin then you are inserting into the user ID, key, and value columns. Wp_capabilities is the actual text you are inserting.

The user ID is the user ID.  The key is wp_capabilities, the value is that string from my original post.

Then repeat with user ID, wp_user_level, and 10

<div>
That was it....thanks again. Worked like a charm.
</div>


That was it....thanks again. Worked like a charm.

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
Two parts: <br />
<br />
How can I tell which WP user is an administrator via phpmyadmin?<br />
<br />
I need to create a new admin user via phpmyadmin. The few sites I found that list the steps and the query seem to have problems with the code (as I read the comments on those pages). And I've not done a query before.<br />
<br />
I've taken a backup of the database, and this site is on WordPress 3.8.5<br />
<br />
thx
</div>
</div>


Hi 

Two parts: 

How can I tell which WP user is an administrator via phpmyadmin?

I need to create a new admin user via phpmyadmin. The few sites I found that list the steps and the query seem to have problems with the code (as I read the comments on those pages). And I've not done a query before.

I've taken a backup of the database, and this site is on WordPress 3.8.5

thx

Wordpress - create new admin user via phpmyadmin

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.

WordPress

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.