ManthanHD

Findings, thoughts and observations from the eye of a Software Engineer.

  • Findings
  • Agile
  • Thoughts
  • Educational
  • Skills
  • Random

php

Changing MySQL username and password used by PHPMyAdmin

20th April 2013 / Leave a Comment

So, I had to do this the other day and I got a bit confused. After poking around a bit, I finally found it. If you have xampp installed, go to the install directory. In my case, this directory is C:xampp which is the default directory. Locate the phpmyadmin folder and open it. Locate the config.inc.php file within the phpmyadmin folder. Open up the file. You need to make change in the following two lines:

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

The underlined parts are the ones that you’ve got to change. This file contains a lot of admin stuff so make sure you look around a bit and understand what it does.

If you don’t know what you are doing, ensure you take a backup of the file before changing things.

Did you find this post useful? Spread the word!

  • Facebook
  • Twitter
  • LinkedIn
  • Reddit
  • WhatsApp
  • More
  • Email
  • Skype

Like this:

Like Loading...
Posted in: Findings Tagged: mysql, php, phpmyadmin

Subscribe to Blog via Email

Join 283 other subscribers.
  • RSS – Posts
  • RSS – Comments

Archives

  • June 2021
  • October 2020
  • September 2020
  • August 2020
  • May 2020
  • August 2018
  • June 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • September 2017
  • August 2017
  • July 2017
  • May 2017
  • April 2017
  • March 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • September 2014
  • December 2013
  • October 2013
  • September 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • January 2013
  • December 2012
  • August 2012
  • April 2012
  • February 2012
  • January 2012

Copyright © 2023 ManthanHD.

Me WordPress Theme by themehall.com

%d bloggers like this: