Solved

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

Posted on 2011-09-26
6
659 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 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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
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…
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…

632 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