Solved

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

Posted on 2011-09-26
6
634 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
Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

679 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