Solved

phpMyAdmin lost Passsword - \\localhost\c$\xampp\phpMyAdmin

Posted on 2011-09-26
6
613 Views
Last Modified: 2012-05-12
Hi, I have lost the phpMyAdmin password i used to create a local webserver running xampp/Joomla.

It is set up on a Win7 Pro PC

I can access the local files via path >> \\localhost\c$\xampp\phpMyAdmin

I've tried all the passwords i woudl usually use but getting no joy.

Is there away of resetting the phpMyAdmin password through local files ?

Thank you for your time.
0
Comment
Question by:rookeydooks
  • 3
  • 3
6 Comments
 
LVL 35

Accepted Solution

by:
torimar earned 500 total points
ID: 36598826
Go to the folder c:\xampp\phpmyadmin and open the file config.inc.php in a text editor. Your current password should be displayed in this line:

$cfg['Servers'][$i]['password'] =

Open in new window


Notes:
-- if there is only a ' ' at the end of that line, then the password is still undefined/empty.
-- the PhpMyAdmin user/pass needs to be the same as the MySQL user/pass - keep that in mind if you wish to reset the password.
0
 

Author Comment

by:rookeydooks
ID: 36598899
Hi torimar, many thanks for you quick reply.

It looks like it is empty:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type']            = 'config';
$cfg['Servers'][$i]['user']                 = 'root';
$cfg['Servers'][$i]['password']             = '';
$cfg['Servers'][$i]['AllowNoPassword']      = true;

How would i reset this password ? Is it as easy as typing a  new on in the ' ' ?

How can i test if i know the MySQL Password ? Is there a path to a login page or a file that displays the password ?
0
 
LVL 35

Assisted Solution

by:torimar
torimar earned 500 total points
ID: 36599019
Yes, your current password is empty/undefined.
The reason for this most likely is that you haven't fully completed the XAMPP installation, and hence MySQL as well has the default empty password.

Please make sure you followed the XAMPP installation instructions carefully, and all services (apache, mysql) are actually running. Then open XAMPP in your browser and follow the instructions on the security page (http:/localhost/security ). This will automatically configure and set a MySQL/PHPMyAdmin password.

Only then should you proceed with starting to install Joomla.

If you wish to set a pasword manually, here's how:
http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:rookeydooks
ID: 36599833
Perfect ! Thanks torimar.

I have entered a MySQL password which also lets me in to PhpMyAdmin.

Thank you so much for all your help and time.
0
 

Author Closing Comment

by:rookeydooks
ID: 36599844
Fast and accurate easy to follow support from torimar. A credit to Experts Exchange !
0
 
LVL 35

Expert Comment

by:torimar
ID: 36600311
Thank you for grading. Have fun with your new personal web server!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now