Can’t change user information in the data base.

  • Mahari69

    (@mahari69)


    4 years ago

    Hello!
    Since a couple of days I can’t access to my Admin login.
    Without any changes, not even using the admin level (back end), suddenly it won’t accept my login.
    I get the message that there’s no such user known.
    The option of the admin login screen “Lost password?” don’t work.
    I don’t receive any email.
    Y already tried modificating the “funtions.php” by adding “wp_set_password ( ‘password’ , 1 ) ;”
    to the code.

    Without any result!

    I have MySQLAdmin access and but I stuck at this point. My problem to go on with this way of solution are some doubt’s.
    The instructions are saying y have to find in the “data base” the “wl_users” table, but I can’t find it.
    I have two data bases. I think that’s why I have woocomerce installed.
    One is called “duto_es_” that should be the store and the other one is “wordpress_”.
    What I can find is a table called “I4i6Y_users” in the “wordpress_” space and “du_users” in “duto_es_”.
    Both are having a similar first line. Same “user_nicename”, “user_email” and “user_url”
    But there are different in the “user_login” column. “WP” shows “duto” meanwhile “duto_es” shows “AnonymousFox_vcx”.
    That seams strange to me and it’s the reason why I prefer to ask first before I’ll modify this user. The date of the user registration is from 2014, so I don’t know if it can be hacked lately or if this is a save sign that not.
    Should be the admin information and password the same in both data bases?
    To make a backup of the data bases it’s enough to copy via ftp client a the folder to my desktop hd?
    Anything else to know before I should modify this account in the data base?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Vijay Hardaha

    (@vijayhardaha)

    4 years ago

    In your wp-config.php file look for $table_prefix and define( 'DB_NAME' you will fine your database name and table prefix there then using those values, open your {table_prefix}_users table. look for the record that you thank is admin and was used by you, then edit that record, type the new password in user_pass and in function dropdown choose md5 this is required to choose then save the changes. then try to login with username and new password.

    Thread Starter Mahari69

    (@mahari69)

    4 years ago

    Thank you! I got it fixed!
    I made a copy of both data bases and put in the original ones, the same admin dates, with new password in both. Now I can get in.
    Thank you a lot!

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

The topic ‘Can’t change user information in the data base.’ is closed to new replies.