WordPress.org

Ready to get started?Download WordPress

Forums

[closed] Create New wp_users Table in phpMyAdmin (cpanel) (4 posts)

  1. seth12ut
    Member
    Posted 1 year ago #

    After a change was made in my database, I can no longer login to my wordpress dashboard. After looking at the database, the wp_users table is no longer there. How can I create a new wp_users table that would enable me to login to my website? I need help making the table through phpMyAdmin through cPanel.

  2. Eric Hoanshelt
    Member
    Posted 1 year ago #

    First off, do you have a backup you could restore from? That would be the easiest method. One thing you might want to check for is that PHPmyadmin isn't hiding the wp_users table. PHPmyadmin will use pagination to split up the tables into pages. Be sure that wp_users isn't on a different page in phpmyadmin.

    If all that checks out, here is a SQL line you can run to recreate the tables:

    http://pastebin.com/geExBmD9

    then you will just need to fill in the data once it is created.

  3. markelovett
    Member
    Posted 1 year ago #

    I have also lost my users table in phpmyadmin but I need to know what info to use to create the table.

    In phpmyadmin, after clicking the create table icon, a window opens up requesting information and I need help inputting the info correctly.

    Help!

  4. esmi
    Forum Moderator
    Posted 1 year ago #

    You cannot recreate a wp_users database table. Try restoring a recent database backup. And, next time, please post your own topic.

Topic Closed

This topic has been closed to new replies.

About this Topic