cannot change admin password, wordpress on godaddy

Goto PHPMYADMIN and run below commands in the SQL button.

Change username and password given in query.

INSERT INTO wp_users (user_loginuser_passuser_nicenameuser_emailuser_status) VALUES (‘admin123’, MD5(‘pass123’), ‘firstname lastname’, ’[email protected]’, ‘0’);

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

INSERT INTO wp_usermeta (umeta_iduser_idmeta_keymeta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);

Leave a Comment