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

 

Meer Basit is the founder of Meer’s World. He’s been running the show since launching the blog back in 2018. By background he is a computer scientist. Primarily, he creates content around blogging (WordPress, Blogger, Tumblr), SEO, affiliate programs, earn-online, reviews, eCommerce, & technology. He has got years of professional experience in web programming, computer programming, databases, data warehousing, & transcription. In general, he likes traveling, gardening, watching movies, is a passionate cricketer, creative writer, and a GSD lover.

25 Comments

25 Comments

  1. Unknown

    April 24, 2020 at 4:06 pm

    Thank you very much! Very helpful

  2. 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 Basit

      June 22, 2020 at 3:07 am

      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)

  3. Son Of KAIVAH

    August 3, 2020 at 2:19 pm

    Excellent and perfect. It worked for me.

  4. Anonymous

    September 3, 2020 at 3:50 pm

    This worked perfectly, Thank you!

  5. Cliff

    October 21, 2020 at 6:04 am

    Thank you!!! This was helpful.

  6. pandimuthu

    November 23, 2020 at 7:44 am

    Thanks very help full

    • Meer Basit

      November 24, 2020 at 3:12 am

      You’re most welcome, Pandimuthu!

  7. Anonymous

    December 17, 2020 at 4:41 am

    excellent and perfect!!

  8. Unknown

    January 6, 2021 at 7:53 am

    wow, it worked. Thanks

  9. Meer Basit

    January 16, 2021 at 3:16 am

    You’re most welcome!

  10. poyraz

    February 20, 2021 at 3:11 pm

    Thank you so much

  11. Buddharraj

    April 28, 2021 at 8:05 am

    well explained.. thank you so much

    • Meer Basit

      April 29, 2021 at 3:19 am

      You’re most welcome, Buddharraj!

  12. Unknown

    May 15, 2021 at 3:30 pm

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

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

To Top