cannot change admin password, wordpress on godaddy

I inherited a web task. I do not have the admin password and trying to change it in the backend via phpmyadmin.

The error I get is:

Incorrect password error for user admin

Error:

in wp-config, i see the following hash schema:

 * @since 2.6.0
 */
define('AUTH_KEY',         'vvvvvvvv');
define('SECURE_AUTH_KEY',  'vvvvvvvv');
define('LOGGED_IN_KEY',    'vvvvvvvv');
define('NONCE_KEY',        'vvvvvvvv');
define('AUTH_SALT',        'vvvvvvvv');
define('SECURE_AUTH_SALT', 'vvvvvvvv');
define('LOGGED_IN_SALT',   'vvvvvvvv');
define('NONCE_SALT',       'vvvvvvvv');

I create password via

http://www.passwordtool.hu/wordpress-password-hash-generator-v3-v4

and insert it into phpmyadmin with no md5 setting (since it’s already hashed), just bare.

same invalid user ‘admin’

DB:

DBname in wp-config.php:

define('DB_NAME', 'i1373493_wp6');

and it matches the one I am editing. I’m in the correct Db and user table.

I do not have CLI access and the logs in the godaddy gui are about useless.

How do I change the WordPress admin password in godaddy?

Answer

Goto PHPMYADMIN and run below commands in the SQL button.

Change username and password given in query.

INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_status) VALUES (‘admin123’, MD5(‘pass123’), ‘firstname lastname’, ’[e-mail]’, ‘0’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);