Can't access database

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

Can't access database

Postby SirChick » 18. February 2009 19:42

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 ?
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Re: Can't access database

Postby Wiedmann » 18. February 2009 19:55

- You are using XAMPP?
- You have changed anything?
- The demopages are working?
- Which XAMPP?
- Which OS?
- MySQL is running?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Can't access database

Postby SirChick » 18. February 2009 20:01

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 :)
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Re: Can't access database

Postby Wiedmann » 18. February 2009 20:47

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)?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Can't access database

Postby SirChick » 18. February 2009 21:10

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.
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Re: Can't access database

Postby Wiedmann » 18. February 2009 21:22

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Can't access database

Postby SirChick » 18. February 2009 21:44

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.
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Re: Can't access database

Postby Wiedmann » 18. February 2009 21:47

Server error!

What can you read in "error.log" (\xampp\apache\logs)?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Can't access database

Postby SirChick » 18. February 2009 22:08

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?
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Re: Can't access database

Postby Wiedmann » 18. February 2009 22:17

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

Did you have the file "C:\xampp\security\xampp.users"?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Can't access database

Postby SirChick » 18. February 2009 22:20

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?
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Re: Can't access database

Postby Wiedmann » 18. February 2009 23:57

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

No

Ok, delete the file "C:\xampp\htdocs\xampp\.htaccess" and see what happens.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Can't access database

Postby SirChick » 19. February 2009 00:03

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/
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Re: Can't access database

Postby Izzy » 19. February 2009 00:50

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?
Last edited by Izzy on 12. March 2009 11:36, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Can't access database

Postby SirChick » 19. February 2009 00:59

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.
SirChick
 
Posts: 68
Joined: 19. June 2007 15:03
Operating System: Windows 7 64 bit

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 52 guests