Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»CMS»WordPress»Reset WordPress Admin Password via SQL or phpMyAdmin

    Reset WordPress Admin Password via SQL or phpMyAdmin

    By RahulDecember 5, 20171 Min Read

    Question – How to reset WordPress admin password via SQL query? How to reset WordPress admin password using phpMyAdmin? How to Reset WordPress forgotten password with SQL query? How to find WordPress default admin password?

    Advertisement

    If you have forgotten your SugarCRM admin password or due to any reason, you are not able to login to SugarCRM with admin user. You can simply check the active admin user using SQL query and reset the password with simple SQL query.

    Reset WordPress Admin Password via SQL

    The first query will fetch show the details of the administrator account based on username.

    1
    SELECT * FROM wp_users WHERE user_login = 'admin';

    If you only have the email address of admin user. Search user details using the command.

    1
    SELECT * FROM wp_users WHERE user_email = '[email protected]';

    WordPress uses md5 encrypted passwords. The query will change the password for the specified username. You must change new_password with your password and ID with the got ID from above queries.

    1
    UPDATE wp_users SET user_pass = md5('new_password') WHERE ID = 1;

    Reset WordPress Admin Password via phpMyAdmin

    You can also connect WordPress database with phpMyAdmin and reset the admin password. Open table wp_users and edit the record of the admin user. Now under the user_pass column, select the MD5 in functions and put plain text password in value section and save it.

    Reset WordPress Admin Password

    admin password reset WordPress
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    How to Generate Random Passwords in Python

    How to Generate Random Password in Python

    10 Simple Ways to Speed Up Your WordPress Website

    10 Simple Ways to Speed Up Your WordPress Website

    How to Git Reset to Head

    How to Git Reset to Head

    Add A Comment

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • System.out.println() Method in Java: A Beginner’s Guide
    • Split Command in Linux With Examples (Split Large Files)
    • Test Your Internet Speed from the Linux Terminal
    • 11 Practical Example of cat Command in Linux
    • sleep Command in Linux with Examples
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.