Computer Science
How To Set Root Password In phpMyAdmin On XAMPP Server
Published on
Do you want to set root password in phpMyAdmin? You’re in the right place. In this tutorial we will guide you step-by-step to How to set root password in phpMyAdmin on XAMPP Server.
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.
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
Unknown
April 24, 2020 at 4:06 pm
Thank you very much! Very helpful
Meer's World
April 24, 2020 at 7:58 pm
You're welcome.
Creater Hasan
June 21, 2020 at 1:46 pm
oldu çok teşekkür ederim. bu sorunu çözüp php derslerime devam edeceğim için çok mutluyum
Meer's World
June 21, 2020 at 3:11 pm
You are welcome Hasan. Probably you said in Turkish (Thank you very much. I am very happy to solve this problem and continue my php lessons) 🙂
Son Of KAIVAH
August 3, 2020 at 2:19 pm
Excellent and perfect. It worked for me.
Anonymous
September 3, 2020 at 3:50 pm
This worked perfectly, Thank you!
Meer's World
September 3, 2020 at 4:48 pm
You're most welcome.
Abhishek Gandhi
October 13, 2020 at 7:38 am
Hey Thankyou so much for writing this awesome blog it can help me a lot for saving my time. I am also a blogger who can write blogs on such problem related programming please check my blog at https://webxintegrators.com/blog/
Meer's World
October 13, 2020 at 12:03 pm
You're most welcome.
Cliff
October 21, 2020 at 6:04 am
Thank you!!! This was helpful.
Meer's World
October 21, 2020 at 1:35 pm
You're most welcome.
pandimuthu
November 23, 2020 at 7:44 am
Thanks very help full
Meer's World
November 23, 2020 at 11:17 am
You're most welcome.
Unknown
November 29, 2020 at 8:37 am
Thanks
Meer's World
November 29, 2020 at 10:55 am
Welcome.
NuWa Blog
December 3, 2020 at 8:02 am
thank you very much
Meer's World
December 3, 2020 at 12:38 pm
You're most welcome.
Anonymous
December 17, 2020 at 4:41 am
excellent and perfect!!
Unknown
January 6, 2021 at 7:53 am
wow, it worked. Thanks
Meer's World
January 6, 2021 at 11:46 am
You're most welcome.
Unknown
January 15, 2021 at 9:39 am
thanks man. Very well explained in simple way
Meer's World
January 15, 2021 at 11:57 am
You're most welcome.
Unknown
February 7, 2021 at 2:24 am
Thanks
Meer's World
February 7, 2021 at 12:20 pm
You're most welcome.
poyraz
February 20, 2021 at 3:11 pm
Thank you so much
Meer's World
February 20, 2021 at 3:36 pm
You're most welcome.
Buddharraj
April 28, 2021 at 8:05 am
well explained.. thank you so much
Meer's World
April 28, 2021 at 1:43 pm
You're most welcome.
Unknown
May 15, 2021 at 3:30 pm
Well Explained and a Perfect solution. Thank you so much!
Meer's World
May 15, 2021 at 5:02 pm
You're most welcome.
Sayan Chatterjee
May 18, 2021 at 2:28 pm
works like a charm