Create New wp_users Table in phpMyAdmin (cpanel)

  • 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.

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

  • 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:

    https://pastebin.com/geExBmD9

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

    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!

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Create New wp_users Table in phpMyAdmin (cpanel)’ is closed to new replies.