phpmyadmin Question posted in
The official documentation can be found here.

cannot change admin password, wordpress on godaddy – Phpmyadmin

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:

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:

Database

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?

Tags:

2

Answers


  1. 0

    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’, ’[email protected]’, ‘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’);

    Login or Signup to reply.
  2. 0

    Here is the best Solution

    You can change Your WordPress Password from setting or from your Plesk or CPanel

    Step 1: Login In Your Godaddy or Hosting

    Step 2: Open your Hosting Setting

    Step 3: Go to The Application

    Step 4: Click on Your Desire WordPress Site

    Step 5: Click on Setup and change your password

    Because in past I was also stuck in the same issue in my website HRO WEB DEVELOPERS

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search