In the form, enter the password you want to set and click on the ‘Go’.Īfter these steps are done, head over to your editor and open the from the phpmyadmin directory.
On the next screen, click on the ‘Change password’.
Click on the ‘Edit privileges’ from the Action column of this row. We need the last account from the list with the User name as ‘root’ and the Host name as ‘localhost’. You will then see a list of user accounts. Most probably you can access it using Click on the ‘User Accounts’ from the top bar. Using phpMyAdmin, one can set the Root password in a few steps. It just makes developers life easy to manage the database, tables, table structures, queries, and so on. PhpMyAdmin is a fantastic software built for handling your MySQL databases. I am going to show you 3 different ways of resetting the password.
#RESETTING PHPMYADMIN ROOT PASSWORD HOW TO#
That being said, let’s take a look at how to set MySQL Root password.
Though users rarely set the password on the local machine to access phpMyadmin, it’s always a good practice to do so. But on the local server, you have to set credentials yourself. For accessing phpMyAdmin on a live server, your hosting does set the credentials for you. When your application is live, you have to pass both username and password in order to access the database. In this article, I show you 3 possible ways to reset the password for your root account. Do you want to change a password for the root account of your MySQL server? Sometimes you may want to set a password for the account.
0 kommentar(er)
