Forgotten password for system

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Forgotten password for system

Postby nick.kirby » 15. August 2006 05:35

Hello, I'll admit it now, I'm a dingbat. I changed the admin passwod to phpmyadmin after I realised it was the default homepage.

I can assure you this isn't social engineering, just a compelte dunce whose forgotten his password. Is there a way to reset it? I'm told my mail server is blacklisted, yet I haveonly installed it today, thne I wondered if Mercury was in there, and it is.

I'd also like to turn off SSL and what not, but I cannot log in to myadmin. What do I need to do to change this?
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Postby Izzy » 15. August 2006 06:46

Follow the direction for a Windows installation on this page.

http://mysql.com/doc/refman/5.0/en/rese ... sions.html

I just tested it and it worked but I don't use mysqld-nt but I did use it to follow the instructions to the letter for this exercise.

Then I stopped the mysql-nt service that I just started with my new password and restarted the service in my XAMPP Control Panel and the new password allowed me in to phpMyAdmin without any problems.

I think you can change it the my.cnf file but not sure on a Windows installation.

However a Google for reset mysql root password gave some useful results but most were for linux.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby nick.kirby » 15. August 2006 13:40

Hullo, many thanks for that, however I still cannot get into phpmyadmin!

That's where my problems are, when I click on "security" I get a little dialog pop up asking for a username and password, and these I don't know, orhow to reset!
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Postby Izzy » 15. August 2006 13:47

Are you talking about the mySQL root password or are you talking about a user/password you set up for access to your XAMPP directories?
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby nick.kirby » 15. August 2006 13:55

It must be the xampp pages. The sql service is fine, but I appear to have locked myself out entirely of my own webserver!
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Postby Izzy » 15. August 2006 14:06

Thats better now we know what you are talking about.

I don't know if you have this file:
xampp/security/xamppdirpasswd.txt
If you have, open it, as it may contain your user/pass that you lost.

If not follow this proceedure:
Go to the directory xampp/htdocs/xampp/
Find the file .htaccess
Now rename the file to any.htaccess for now (you can delete it later because if you make a new user/pass it will be recreated).

Now find the file \xampp\security\xampp.users
Rename it to any.xampp.user (same applies to this file, it can be deleted later)

Now go to your server http://localhost
You should be able to access it now.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby nick.kirby » 15. August 2006 14:16

Sorry Izzy, did those things, and I get asked for username and password.

I've stopped and restarted Apache in case this affected it, but the problem occurs.
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Postby Izzy » 15. August 2006 14:20

What is in the address bar of your browser when you get the user/pass box?
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby nick.kirby » 15. August 2006 14:25

connect to localhost - I don't get it. The deleting password files should have fixed it!

Senior moment - http://localhost/xampp
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Postby Izzy » 15. August 2006 14:33

nick.kirby wrote:connect to localhost - I don't get it. The deleting password files should have fixed it!

Senior moment - http://localhost/xampp
Senior moment - whats that?

Try deleting your browser's cache. It may be feeding you an old page.

Try finding another .htaccess file in another directory in your xampp/htdocs directory.

What files were in the xampp/security/ directory?

This is odd.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby nick.kirby » 15. August 2006 14:44

Senior moment: when old age defeats your brain momentarily.

I've searched the xampp directory and changed all the .htaccess files to any.htaccess.

However I keep getting asked for the username adn password.
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Postby Izzy » 15. August 2006 14:49

In xampp/security directory do you have a htdocs directory?
If so look in there for a .htaccess file.

Apart from the .htaccess files mentioned in the previous post you should change back all the .htaccess files you changed as they have no effect.

In the .htaccess file you are looking for this or similar
Code: Select all
AuthName "xampp user"
AuthType Basic
AuthUserFile "Path:\\to your\xampp\security\xampp.users"
require valid-user



Senior moment :D
I know what you mean only I get the same thing and they call it alzheimer's. :)
Last edited by Izzy on 15. August 2006 14:56, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby nick.kirby » 15. August 2006 14:55

Yep, I've changed that to any.htaccess.

Still getting the asme request for passwords.

Have restarted Apache, deleted cache files.
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Postby Izzy » 15. August 2006 15:01

No need to restart apache for what we are doing.

In your xampp/apache/conf/httpd.conf file what is your Document root set to?
Code: Select all
#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "Path:/to/your/xampp/htdocs"
Paste it here exactly.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby nick.kirby » 15. August 2006 15:08

DocumentRoot "C:/Program Files/xampp/htdocs"

Out fo interest, is there a way in dos perhaps to remove lines prefixed with a #?

It'd help declutter my config file.
nick.kirby
 
Posts: 12
Joined: 23. January 2006 20:13

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 123 guests