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

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

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

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

Izzy

Posts: 3344
Joined: 25. April 2006 17:06

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

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.

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

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

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

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

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

Senior moment: when old age defeats your brain momentarily.

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

nick.kirby

Posts: 12
Joined: 23. January 2006 20:13

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 BasicAuthUserFile "Path:\\to your\xampp\security\xampp.users"require valid-user

Senior moment
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

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

No need to restart apache for what we are doing.

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

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