1. Home
  2. Technical
  3. MariaDB / MySQL
  4. Changing WordPress admin credentials via phpMyAdmin
  1. Home
  2. Technical
  3. Changing WordPress admin credentials via phpMyAdmin

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). Open your WordPress directory (htdocs by default).
Open the file wp-config.php  (right  click and Edit). 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.

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 Enter the database username and password (MySQL) that you copied from the wp-config.php file.

Changing the user password

In phpMyAdmin click 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. 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.

Updated on 24. Oct 2024
Was this article helpful?

Related Articles