How to View All WordPress Users in Your Database Using Terminal

To see a list of all WordPress users in your database (zzle_wu3), you’ll need to run a SQL query on the wp_users table.

🧾 MySQL Command:

bash
mysql -u root -p -e "SELECT ID, user_login, user_email, user_registered FROM zzle_wu.wp_users;"

πŸ” You will be prompted to enter your MySQL root password.

πŸ“‹ What This Displays:

  • ID: The unique identifier for each user.

  • user_login: The WordPress username.

  • user_email: The email address linked to the account.

  • user_registered: The date and time the user registered.

βœ… Example Output:

You can add \G at the end for vertical format if the output is too wide:

bash
mysql -u root -p -e "SELECT ID, user_login, user_email, user_registered FROM zzle_wu3.wp_users\G

Loading

Leave a Reply

Your email address will not be published. Required fields are marked *