CPanel access but no wordpress user and pass

by 5 replies
7
Hi all, I'm in a little jam here and maybe someone here can help.

I paid someone in this forum to put up a site for me . The un-named person left the site half finished and stopped replying to emails.

Before the relationship ended I did get hosting (cpanel) login details.
But I don't have the wordpress user or password, so I can't work on the site itself.

I'm guessing the user and pass are in the files (I can access the file manager) somewhere, does anyone know how/if I can I can retrieve them ?
thanks , Eric
#programming #access #cpanel #pass #user #wordpress
  • Should be in:
    wp-config.php

    It's the main WP directory with the wp-admin, wp-content, wp-includes folders.
  • Actually the information in wp-config.php is only the MySQL database username and password.

    What you need to do is look in the associated MySQL database for the actual user name. The password is encrypted (MD5) so you won't be able to retrieve it, but using PHP MyAdmin from your CPanel you can change it to something you'll remember.

    If this sounds too much like "rocket science" drop me a line and I can probably help you.

    Bill
  • You have to follow these steps.

    1. Login to cPanel
    2. Click on phpMyAdmin
    3. New interface will open. You will see your existing database in the left frame. Click on appropriate database name from there. If you are many databases and you are not sure which one is you need to work with, open file manager from cpanel and go to the root directory of your wordpress blog. Open wp-config.php and check the line:
      define('DB_NAME','xxxxx');
      This xxxxx is your database name.
    4. After you select the database name, it will show all tables. Click on *users table. * marks means there may be some prefix like wp_. So the name may be like wp_users.
    5. Click on Browse link from the top. It will list all Users. If you check the listed user, you should see something like admin. If not, just concentrate on the first user. Click the Edit button on the respective row.
    6. Editor interface will come. Now enter your new password in the Password field and select MD5 from left column of same row (may be titled as MySQL Function).
    7. Hit Go/Save/Update.
    8. You are done.
    • [1] reply
    • You can have wordpress username and password when you install wordpress it will ask you for that
      • [1] reply
Join the discussion

Next Topics on Trending Feed