New WordPress Login New WordPress DashboardĪ good thing about using the phpMyAdmin dashboard to change Admin user-associated login credentials is that it is fast and flexible. You should now be able to log in back to your WordPress site with the new password. WordPress Admin Password Change Confirmation The below screen capture confirms that the query execution was a success. Under the ID table column, find user_pass and set the varchar(255) value to MD5, and then key in your new Admin user password value. Edit WordPress User TableĬlick Edit on the Admin user whose password you need to change. We can now go back to the wp_users WordPress table and fulfill the objective of this article. If these wp_users ID to wp_usermeta user_id row values reference did not exist, we would only be changing the password of an ordinary WordPress user and not the one for an Admin user. This reference match confirms that the wp_users’ users whose password we want to change are indeed admin users. Also, the wp_usermeta user_id values should be on the same row with wp_capabilities and a:1: values. The wp_users ID should match with wp_usermeta user_id. It should reveal some interesting information. Trace the WordPress database table with the naming convention wp_usermeta and click on it. Gaze back at phpMyAdmin’s dashboard panel on the left. In the above screen capture, the two users’ ID entries are 1 and 3 respectively. The above action should list different database users associated with WordPress’ wp_users database table. It is the WordPress database table that holds all site user’s credential information. On the above exposed WordPress database table list, trace the one with the naming convention “wp_users” and click on it. It is a common rule for WordPress to label or name its database tables with the prefix “wp_”. The above clickable action should reveal all the database tables associated with the main WordPress database. Trace the database associated with your WordPress site and click on it to expand. On the left side of the phpMyAdmin environment, you should see a list of all the MySQL/MariaDB databases that can be manipulated by your privileged database administration powers. From here, you should be able to comfortably log in to the phpMyAdmin dashboard. In my case, I am working from localhost and so I will access phpMyAdmin in the following manner. Accessing phpMyAdmin from a web browser environment requires a user to adhere to the following URL syntax rule. The first step is to trace the phpMyAdmin site from your web browser. MariaDB ()> GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Ĭhanging WordPress Admin Password Using phpMyAdmin MariaDB ()> CREATE USER IDENTIFIED BY 'Pa55word' If you are familiar with the MySQL/MariaDB command-line, you can use its terminal environment to create an alternatively dedicated database user with a command sequence similar to the following. It is not advisable to use the root user to gain access to your phpMyAdmin dashboard. This user should be privileged enough to have access to all your databases and database tables. You should have a dedicated database user for your MySQL/MariaDB server. Changing user passwords involves several easy steps. One such action is resetting your admin password from its Graphical User Interface. One undisputed advantage of using phpMyAdmin as a database management and administration frontend is how easy it is to configure and implement user-privileged actions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |