Connect with us

How To Set Root Password In phpMyAdmin On XAMPP Server

how to set root password in phpmyadmin

Computer Science

How To Set Root Password In phpMyAdmin On XAMPP Server

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.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 1
  • Click User accounts.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 2
  • Look for the row having User name: root & Host name: localhost.
  • You can see that there is No for Password.
  • Click Edit Privileges.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 3
  • Click Change password.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 4
  • Enter Password.
  • Click Go.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 5
  • You can see the password for User name root has been set successfully.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 6
  • Now go back to localhost.
  • Click phpMyAdmin.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 7
  • You can see that it is showing an error.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 8

Step 2:

  • Now go to XAMPP folder.
  • Click sub folder phpMyAdmin
  • Look for the file config.inc.php
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 10
  • Right click on config.inc.php.
  • Openwith Notepad or WordPad or Notepad++
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 11

Look for these two lines:

  •    $cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
  •    $cfg[‘Servers’][$i][‘password’] = ”;
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 13
  • Replace ‘config’ with ‘cookie’
  • Enter your Password that you have created earlier on empty space.
  • Save the file.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 14
  • Now go back to that page again & Refresh or access phpMyAdmin again.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 15
  • You can see that the error has been removed.
  • Now enter the User name: root & your Password.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 16
  • After login, it will look like this.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 17
  • You can see that Password is Yes.
  • Now your phpMyAdmin is secure.
How To Set Root Password In phpMyAdmin/MySQL On XAMPP In Windows 10 18

 

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

 

Best web hosting

 

Recommended Posts

 

31 Comments

31 Comments

  1. Unknown

    April 24, 2020 at 4:06 pm

    Thank you very much! Very helpful

  2. Meer's World

    April 24, 2020 at 7:58 pm

    You're welcome.

  3. 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

  4. 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) 🙂

  5. Son Of KAIVAH

    August 3, 2020 at 2:19 pm

    Excellent and perfect. It worked for me.

  6. Anonymous

    September 3, 2020 at 3:50 pm

    This worked perfectly, Thank you!

  7. Meer's World

    September 3, 2020 at 4:48 pm

    You're most welcome.

  8. 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/

  9. Meer's World

    October 13, 2020 at 12:03 pm

    You're most welcome.

  10. Cliff

    October 21, 2020 at 6:04 am

    Thank you!!! This was helpful.

  11. Meer's World

    October 21, 2020 at 1:35 pm

    You're most welcome.

  12. pandimuthu

    November 23, 2020 at 7:44 am

    Thanks very help full

  13. Meer's World

    November 23, 2020 at 11:17 am

    You're most welcome.

  14. Unknown

    November 29, 2020 at 8:37 am

    Thanks

  15. Meer's World

    November 29, 2020 at 10:55 am

    Welcome.

  16. NuWa Blog

    December 3, 2020 at 8:02 am

    thank you very much

  17. Meer's World

    December 3, 2020 at 12:38 pm

    You're most welcome.

  18. Anonymous

    December 17, 2020 at 4:41 am

    excellent and perfect!!

  19. Unknown

    January 6, 2021 at 7:53 am

    wow, it worked. Thanks

  20. Meer's World

    January 6, 2021 at 11:46 am

    You're most welcome.

  21. Unknown

    January 15, 2021 at 9:39 am

    thanks man. Very well explained in simple way

  22. Meer's World

    January 15, 2021 at 11:57 am

    You're most welcome.

  23. Unknown

    February 7, 2021 at 2:24 am

    Thanks

  24. Meer's World

    February 7, 2021 at 12:20 pm

    You're most welcome.

  25. poyraz

    February 20, 2021 at 3:11 pm

    Thank you so much

  26. Meer's World

    February 20, 2021 at 3:36 pm

    You're most welcome.

  27. Buddharraj

    April 28, 2021 at 8:05 am

    well explained.. thank you so much

  28. Meer's World

    April 28, 2021 at 1:43 pm

    You're most welcome.

  29. Unknown

    May 15, 2021 at 3:30 pm

    Well Explained and a Perfect solution. Thank you so much!

  30. Meer's World

    May 15, 2021 at 5:02 pm

    You're most welcome.

  31. Sayan Chatterjee

    May 18, 2021 at 2:28 pm

    works like a charm

Leave a Reply

Your email address will not be published.

More in Computer Science

Advertisement
Advertisement
Best Online Trendy Money Making Skills
Get Namecheap Shared Hosting With Free Domain
Download Cheap Website Themes
To Top