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
Solved

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

Posted on 2011-09-26
6
630 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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

860 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