Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-09-26
6
Medium Priority
?
668 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 35

Accepted Solution

by:
torimar earned 2000 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 2000 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Google Certified Professional - Cloud Architect

This course (1 of 3) is designed to help students who are interested in Google Cloud Platform (GCP) to become familiar with the platform, navigate the console and learn its capabilities. It will also prepare students for the Google Cloud Architect certification exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

704 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