Skip to main content

Changing the Root Password

You will want to change your root password (local user that is given all privilidges)
This account is your most important account so you will want to change the password within the MySQL application as well as within XAMPP so it can log into it with the correct credentials.

You will now want to click on User Accounts on the homepage of your PHPmyadmin\

After that, you will want to click on all of your root accounts and change the passwords to what ever you want them to be.

Once you change these, you will not be able to log back into your PHPmyadmin until you change the credentials inside of XAMPP.
To do this, you will need to reopen your XAMPP interface and go to the following.

Press Explorer then go to this file path C:\xampp\phpMyAdmin\config.inc.php (assuming you downloaded this onto your main drive)\

You will then want to open that file with your preferred text editor and go to the line

$cfg['Servers'][$i]['password'] = ' ';

Inside of that quotes AFTER ['password'] = you will enter the password you set for your root accounts.

Now your Databases are protected on your local network or anyone trying to access the root account from an external endpoint.\