Title: issue with phpMyAdmin and users table
Last modified: August 19, 2021

---

# issue with phpMyAdmin and users table

 *  [redraider90](https://wordpress.org/support/users/redraider90/)
 * (@redraider90)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/issue-with-phpmyadmin-and-users-table/)
 * Hello,
 * I have a standard wp_users table which contains the basic info – id, username,
   pwd, etc.
 * Somewhere address and phone numbers and other data is stored, but I can’t find
   any looking through and querying the tables I see. Is it possible or does WP 
   in phpMyAdmin hide certain tables, where an admin user wouldn’t be able to edit
   them?
    I am totally mystified by this, but in WordPress in the users screen I
   can see an array of data fields (with values) for which I don’t find in any of
   the tables I see.
 * I’m wide open to suggestion if anyone has any basic insight to this problem!
 * Thanks,
 * redraider90
    -  This topic was modified 4 years, 8 months ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).
      Reason: Moved to Fixing WordPress, this is not an Developing with WordPress
      topic

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/issue-with-phpmyadmin-and-users-table/#post-14781781)
 * User meta data like real names, bio, etc., are normally saved in the wp_usermeta
   table under various key names. Search the table by user ID to see all meta data
   saved for a particular user.
 * It’s conceivable that additional fields beyond the default ones, added via plugin
   or theme, are saved elsewhere, such as a custom table inserted for the purpose.
   Which table that would be depends on the plugin or theme, but it wouldn’t be 
   [one of the default ones](https://codex.wordpress.org/Database_Description#Table_Overview).
 * If you know a specific value you’re looking for, it’s possible in phpMyAdmin 
   to search all tables and all columns for a value. Click on the DB name in the
   left pane, then go to the search tab.
 *  Thread Starter [redraider90](https://wordpress.org/support/users/redraider90/)
 * (@redraider90)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/issue-with-phpmyadmin-and-users-table/#post-14782196)
 * Thank you, bcworkz.
 * I did indeed find some additional data in the user meta table. So I do see some
   fields.
    Like you said, there are additional fields and I see how to add them
   via one of the admin pages. I just could not find various values in fields in
   tables, associated with known users. I’ll try searching the DB for all tables
   and see if I can do that like you are suggesting.
 * Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘issue with phpMyAdmin and users table’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [redraider90](https://wordpress.org/support/users/redraider90/)
 * Last activity: [4 years, 8 months ago](https://wordpress.org/support/topic/issue-with-phpmyadmin-and-users-table/#post-14782196)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics