Apache Friends Support Forum


https://community.apachefriends.org/f/

Can't access database

https://community.apachefriends.org/f/viewtopic.php?f=16&t=33537

Page 1 of 2

Can't access database

PostPosted: 18. February 2009 19:42
by 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 ?

Re: Can't access database

PostPosted: 18. February 2009 19:55
by Wiedmann
- You are using XAMPP?
- You have changed anything?
- The demopages are working?
- Which XAMPP?
- Which OS?
- MySQL is running?

Re: Can't access database

PostPosted: 18. February 2009 20:01
by 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 :)

Re: Can't access database

PostPosted: 18. February 2009 20:47
by 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)?

Re: Can't access database

PostPosted: 18. February 2009 21:10
by 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.

Re: Can't access database

PostPosted: 18. February 2009 21:22
by 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.

Re: Can't access database

PostPosted: 18. February 2009 21:44
by 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.

Re: Can't access database

PostPosted: 18. February 2009 21:47
by Wiedmann
Server error!

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

Re: Can't access database

PostPosted: 18. February 2009 22:08
by 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?

Re: Can't access database

PostPosted: 18. February 2009 22:17
by Wiedmann
Hmm, this "C:C:" is wrong.

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

Re: Can't access database

PostPosted: 18. February 2009 22:20
by 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?

Re: Can't access database

PostPosted: 18. February 2009 23:57
by 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.

Re: Can't access database

PostPosted: 19. February 2009 00:03
by 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/

Re: Can't access database

PostPosted: 19. February 2009 00:50
by 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?

Re: Can't access database

PostPosted: 19. February 2009 00:59
by 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.
All times are UTC + 1 hour
Page 1 of 2
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/