Mysql> SET PASSWORD FOR = PASSWORD('root1234')
At the MySQL prompt type the following:. Start MySQL Prompt: Click MySQL Console button. Note: The following assumes the current password is root123 and the new password is root1234 substitute for these as appropriate.įirst start both servers using UniController and proceed as follows: Setting a new MySQL root password using MySQL Prompt requires two root accounts to be changed along with one configuration file. Set New MySQL root user password using MySQL Prompt This is purely for convenience and one of consistency. Note: The above root user accounts all use the same root password. Run phpMyAdmin and verify that the MySQL server is accessible. Clear your browser's cache and restart the servers. Replace root12 with the new root password root123. Edit file C:\UniServerZ\htpasswd\ passwd.txt. Note: Do not stop the MySQL server at this point. Navigate to the end of the Privileges User Overview page and click reload the privileges link. Repeat step 2) for the remaining user (3). Click Go (6) to unpdate the user's password. Scroll down the page to Change passwordįor example root123 (4) repeat password (5). Click the first Edit Privileges (2) which opens a new page: "Edit Privileges: User". The user privileges page opens, as shown on right: From the top menu bar of phpMyAdmin, click the Privileges (1) button. To change the password proceed as follows: Note: The following assumes the current password is root12 and the new password is root123 substitute for these as appropriate.įirst start both servers using UniController and then start phpMyAdmin. Setting a new MySQL root password using phpMyAdmin requires two root accounts to be changed along with one configuration file. Set New MySQL root user password using phpMyAdmin Note: Clicking the cancel button no action is taken. The Set New MySQL Password menu opens (See image on right). Starting UniController provides the first opportunity to change the current root password, it is highly recommended that you set this password at the first opportunity.Īlternatively you can skip setting a new MySQL root password and run this menu option later using: Set New MySQL root user password using UniController 
Set New MySQL root user password using MySQL Prompt.Set New MySQL root user password using phpMyAdmin.Set New MySQL root user password using UniController.This should reset your WordPress password. MD5 is basically message digest algorithm which will save your password in a cryptographic hash value.Īfter entering a new password and selecting the MD5 function, click on Go button at the bottom of the page. On this page, enter a new password in the password field and select MD5 from the function dropdown. This will bring up some sort of a form page. Just click on Edit button for the user whose password you want to reset. Once you select wp_users, you can see the total number of users who have registered on your WordPress site.
In this case, I select the database named ad.Īfter selecting the database, click on wp_users from the right panel – as shown below! Select the database which contains the password which you want to reset. If you are running WordPress on linux server, just log into the cPanel and find phpMyAdmin under databases section! Just left click on WAMP tray icon and select phpMyAdmin from the list. If you are running WordPress on localhost using WAMP then it’s easy peasy for you. This method requires you to have an access to phpMyAdmin. And I always use this quick little method to reset the WordPress password. As I wrote in my previous post, I often forget passwords to WordPress sites which I administrate.
0 kommentar(er)
