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 3 years, 2 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Developing with WordPress topic
Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    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.

    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

    (@redraider90)

    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.