How to change the WordPress admin password directly in the database

Follow these steps to change directly password:

1. Access your database: Use phpMyAdmin or similar tool to access WordPress database

2. Locate the users table: This table is likely named '-----_user'

3. Find the admin user: Identify the row corresponding to the admin user you want to modify. Click edit.

4. Edit password: WordPress uses a complex hashing algorithm for passwords. You could choose MD5 hash.

5. Click Go to apply the changes.

Or you can use sql:

UPDATE wp_users SET user_pass = MD5('your_new_password') WHERE user_login = 'your_username';