How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 - Step By Step

XAMPP is one of the best open source web server to run your PHP sites locally in your computer. It installs Apache, MySQL, PHP & PERL in your computer. XAMPP is a cross-platform solution means it can be installed on Windows, Linux & Mac.

By default XAMPP doesn't set password for phpMyAdmin. To secure your phpMyAdmin you need to set a password. You can access phpMyAdmin directly from Localhost & set password.

In this tutorial you will learn step-by-step to How to set root password in phpMyAdmin on XAMPP Server.

• Follow the steps:

Step 1:

• Open localhost.
• Click phpMyAdmin.

• Click User accounts.

• Look for the row having User name: root & Host name: localhost.
• You can see that there is No for Password.
• Click Edit Privileges.

• Click Change password.

• Enter Password.
• Click Go.

• You can see the password for User name root has been set successfully.

• Now go back to localhost.
• Click phpMyAdmin.

• You can see that it is showing an error.

Step 2:

• Now go to XAMPP folder.
• Click sub folder phpMyAdmin
• Look for the file config.inc.php

• Right click on config.inc.php.
• Openwith Notepad or WordPad or Notepad++

Look for these two lines:

•    $cfg['Servers'][$i]['auth_type'] = 'config';
•    $cfg['Servers'][$i]['password'] = '';

• Replace 'config' with 'cookie'
• Enter your Password that you have created earlier on empty space.
• Save the file.

• Now go back to that page again & Refresh or access phpMyAdmin again.

• You can see that the error has been removed.
• Now enter the User name: root & your Password.

• After login, it will look like this.

• You can see that Password is Yes.
• Now your phpMyAdmin is secure.

• If you like this post don't forget to share this post with other people. Share your feedback in the comments section below.
  

 

Recommended Posts

• How To Install & Configure XAMPP On Windows 10 - Step By Step | For Beginners
• How To Change The XAMPP Server Port In Windows 10 | XAMPP Apache Server Port | Fix Apache Port Error
• How To Install MAMP On Windows 10 Step By Step | How To Change The MAMP Server Ports
• How To Install WordPress On MAMP Server In Windows 10 - Step By Step | Install WordPress On Localhost
• How To Install EasyPHP Devserver On Windows 10 - Step By Step | Show Databases On phpMyAdmin In EasyPHP 
• How To Install PHP On IIS In Windows 10 Step-By-Step | Install IIS On Windows 10
• How To Install WampServer On Windows 10 - For Beginners | How To Run Website From Localhost

Related Posts