---
title: "Changing WordPress admin credentials via phpMyAdmin"
canonical_url: "https://www.speedzone.fi/tuki/en/kb/changing-wordpress-admin-credentials-via-phpmyadmin/"
post_type: "ht_kb"
published: "2024-10-18T07:27:57+00:00"
modified: "2024-11-26T09:32:19+00:00"
language: "en"
author: "silver"
taxonomies:
  ht_kb_category:
    - name: "MariaDB / MySQL"
      url: "https://www.speedzone.fi/tuki/en/kb-categories/mariadb-mysql-en/"
    - name: "Technical"
      url: "https://www.speedzone.fi/tuki/en/kb-categories/technical-en/"
    - name: "WordPress"
      url: "https://www.speedzone.fi/tuki/en/kb-categories/wordpress-en/"
  ht_kb_tag:
    - name: "CMS"
      url: "https://www.speedzone.fi/tuki/en/kb-tags/cms/"
    - name: "credentials"
      url: "https://www.speedzone.fi/tuki/en/kb-tags/credentials/"
    - name: "db_user"
      url: "https://www.speedzone.fi/tuki/en/kb-tags/db_user/"
    - name: "MariaDB"
      url: "https://www.speedzone.fi/tuki/en/kb-tags/mariadb/"
    - name: "phpMyAdmin"
      url: "https://www.speedzone.fi/tuki/en/kb-tags/phpmyadmin/"
    - name: "wordpress"
      url: "https://www.speedzone.fi/tuki/en/kb-tags/wordpress-en/"
---

# Changing WordPress admin credentials via phpMyAdmin

In case the ”forgot password” link on the WordPress login page fails, you can change the admin account password directly from the WordPress database.

### Database admin credentials

You’ll need the user credentials to access the database, you can find the credentials within `wp-config.php` by accessing WebFTP or FTP.Enter `My Zone` ->`Services Overview` -> `Files` (this opens WebFTP). [![](https://www.speedzone.fi/static/sites/5/wpcredentials1.png)](?hkb-redirect&nonce=50c7a9e1b6&check=65eqm&redirect=https%3A%2F%2Fwww.speedzone.fi%2Ftuki%2F%3Fattachment_id%3D10518&otype=unknown&oid=0&source=block-content) Open your WordPress directory (**htdocs** by default).[![](https://www.speedzone.fi/static/sites/5/wpcredentials2.png)](?hkb-redirect&nonce=50c7a9e1b6&check=3grom&redirect=https%3A%2F%2Fwww.speedzone.fi%2Ftuki%2F%3Fattachment_id%3D10519&otype=unknown&oid=0&source=block-content) Open the file `wp-config.php` (right click and `Edit`). [![](https://www.speedzone.fi/static/sites/5/wpcredentials3.png)](?hkb-redirect&nonce=50c7a9e1b6&check=2s1r1&redirect=https%3A%2F%2Fwww.speedzone.fi%2Ftuki%2F%3Fattachment_id%3D10520&otype=unknown&oid=0&source=block-content) The database username and password can be found between `define()` functions. Username as `DB_USER` and password as `DB_PASSWORD`, the credentials will be seperated with **‘** and **“**.  Temporarily copy the credentials to a separate text file for easy access.

 [![](https://www.speedzone.fi/static/sites/5/wpcredentials4.png)](?hkb-redirect&nonce=50c7a9e1b6&check=7pmrf&redirect=https%3A%2F%2Fwww.speedzone.fi%2Ftuki%2F%3Fattachment_id%3D10521&otype=unknown&oid=0&source=block-content)### Accessing the database (phpMyAdmin)

The easiest way to connect to a database is through the phpMyAdmin environment. If you still have the `My Zone` control panel open in a separate tab, you can access the phpMyAdmin environment from there by selecting `Databases` from the left web hosting management menu and under it `phpMyAdmin`. If you have already managed to close `My Zone`, direct link to phpMyAdmin: <https://pma.hel01.zone.eu/> When following a direct link, first enter your domain name without the www prefix (for example, domain.fi) and click `Log in` [![](https://www.speedzone.fi/static/sites/5/phpMyAdmin.png)](?hkb-redirect&nonce=50c7a9e1b6&check=4u9i8&redirect=https%3A%2F%2Fwww.speedzone.fi%2Ftuki%2Fen%2Fkb%2Fhow-to-access-phpmyadmin%2Fphpmyadmin%2F&otype=unknown&oid=0&source=block-content) Enter the database username and password (MySQL) that you copied from the wp-config.php file. [![](https://www.speedzone.fi/static/sites/5/phpMyAdmin2-1.png)](?hkb-redirect&nonce=50c7a9e1b6&check=5jj42&redirect=https%3A%2F%2Fwww.speedzone.fi%2Ftuki%2Fen%2Fkb%2Fhow-to-access-phpmyadmin%2Fphpmyadmin2-2%2F&otype=unknown&oid=0&source=block-content)

### Changing the user password

In **phpMyAdmin c**lick on the database name in the left block, then select `wp_users` in the following menu (tables can have a different prefix instead of wp). In the admin user account row, click `Edit`. If you installed WordPress on the server via Zone+, the username of the administrator account is `zoneplus`. If you install WordPress manually, this may be `admin`. [![](https://www.speedzone.fi/static/sites/5/wpcredentials7.png)](?hkb-redirect&nonce=50c7a9e1b6&check=3aoit&redirect=https%3A%2F%2Fwww.speedzone.fi%2Ftuki%2F%3Fattachment_id%3D10522&otype=unknown&oid=0&source=block-content) Find the `user_pass` row in the account edit table and select `MD5` from the drop-down menu in the `Function` column. Then enter the new password in the text field in the `Value` column and confirm the change with the `Function` button in the lower right corner of the page. Finally, try logging into WordPress with your new password.