1. Home
  2. Technical
  3. MariaDB / MySQL
  4. Changing WordPress admin credentials via phpMyAdmin
  1. Home
  2. Wordpress
  3. 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 access your database is by doing so via pma.zone.ee.
You’ll need to enter your domain name and database user credentials.

Changing the user password

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 account row, click edit.

Attention!

If you installed WordPress via Zone+, the admin account username will be zoneplus

Updated on 13. Jun 2023

Was this article helpful?

Related Articles