Can't access database

[SirChick]

I try to load up my database to edit it but i get this:

Error

MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Where do i find the configuartion file so it works.. i searched the word "config" but like it found a fair few in the directory =/ Where is the precise location of the one i need to edit ?

[Wiedmann]

- You are using XAMPP?
- You have changed anything?
- The demopages are working?
- Which XAMPP?
- Which OS?
- MySQL is running?

[SirChick]

The only thing i changed was to have it having a password but it doesn't ask me to login it just says cannot access.

1)Xampp
2) as stated above
3)I can't get access to any thing i just get the error in my first posted
4) Most recent version
5)I am using Windows Vista
6)Yes it is running according to my Xampp Control Panel

Hope you can help

[Wiedmann]

I can't get access to any thing i just get the error in my first posted

OK, your first post is about phpMyAdmin. What's about the demopages (cd demo)?

[SirChick]

Not sure i know what they are .. do you mean access php files etc in my htdocs? which is what i thought you meant if so, then those i can access.

[Wiedmann]

do you mean access php files etc in my htdocs?

I mean the demopage from XAMPP at http://localhost/xampp/ And the CD demo which you can find there.

[SirChick]

I tried viewing this:

http://localhost/xampp/cds.php

Also tried:
http://localhost/xampp

To get directory of files or for it to go to index.php not sure if there was one

And it is in my "htdocs > xampp > cds.php"


But localhost shows:

Server error!

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

Not sure why cos its deffinately correct url my website scripts load when which are in subfolders but not xampp's folder.

[Wiedmann]

Server error!

What can you read in "error.log" (\xampp\apache\logs)?

[SirChick]

Ok its given me this:

[Wed Feb 18 20:41:47 2009] [alert] [client 127.0.0.1] C:/xampp/htdocs/xampp/.htaccess: Invalid file path C:C:\\xampp\\security\\xampp.users, referer: viewtopic.php?f=16&t=33537&p=136144
[Wed Feb 18 20:42:39 2009] [alert] [client 127.0.0.1] C:/xampp/htdocs/xampp/.htaccess: Invalid file path C:C:\\xampp\\security\\xampp.users
[Wed Feb 18 20:42:44 2009] [alert] [client 127.0.0.1] C:/xampp/htdocs/xampp/.htaccess: Invalid file path C:C:\\xampp\\security\\xampp.users
[Wed Feb 18 20:44:50 2009] [alert] [client 127.0.0.1] C:/xampp/htdocs/xampp/.htaccess: Invalid file path C:C:\\xampp\\security\\xampp.users

Has something gone missing?

[Wiedmann]

Hmm, this "C:C:" is wrong.

Did you have the file "C:\xampp\security\xampp.users"?

[SirChick]

No I have this:

C:\xampp\security\¬
files in the folder:
htdocs
webdav.htpassword


In htdocs is aload of php files which i've never touched before.. i ain't touched the security folder ever.

What do you think went wrong?

[Wiedmann]

Did you have the file "C:\xampp\security\xampp.users"?

No

Ok, delete the file "C:\xampp\htdocs\xampp\.htaccess" and see what happens.

[SirChick]

Still get:

MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

On this link:
http://localhost/phpmyadmin/

[Izzy]

Still trying to test XAMPP is working so we can go forward to the phpMyAdmin issue.

Clear your browser's cache next.

After deleting the .htaccess in the xampp\htdocs\xampp folder can you now go to (try first) http://localhost or try next http://localhost/xampp, then try out the demos in the left column menu of the XAMPP Welcome Page?

[SirChick]

Argh, im on the welcome page that now works

But obviously phpmyadmin still does not. Is there anything i need to sort out in the xampp to fix phpmyadmin or is it unrelated to it?

Note:

I get:

Access forbidden!

When i click security on the xampp welcome page etc... is this meant to happen ? From what i remember it used to let me view it. Thought i'd mention that.