Jump to content


PhpMyAdmin


7 replies to this topic

#1 Chris.

    Young Padawan

  • Members
  • Pip
  • 129 posts
  • Gender:Male

Posted 14 May 2007 - 04:27 PM

I'm not sure if this is the right section or not for posting this, but I think it is.

Well, I have WAMP setup on my computer, but I want to protect my PhpMyAdmin directory by using a username and password. In the config.inc.php file I change the auth_type to http, the username, and set a password. When I went to the phpmyadmin directory, it showed the prompt to login. So, I entered the information, and it showed the prompt again. I entered my account information again, and this kept happening. I was like "wtf is going on here" so, I checked my access.log file, and this is what it said

Quote

127.0.0.1 - - [14/May/2007:17:15:32 -0400] "GET /phpmyadmin/ HTTP/1.1" 401 903
127.0.0.1 - root [14/May/2007:17:15:35 -0400] "GET /phpmyadmin/ HTTP/1.1" 401 903
127.0.0.1 - - [14/May/2007:17:15:37 -0400] "GET /phpmyadmin/css/phpmyadmin.css.php?token=df0d8f5075e4a1165117c914a6bf41cd&js_frame=right HTTP/1.1" 200 20303

I'm not really sure what that means, but maybe someone else does. Does anyone know how to get this http authorization to work? Has anyone else had this problem, and if so, how did you fix it?

Thanks!

#2 Demonslay

    P2L Jedi

  • Members
  • PipPipPip
  • 970 posts
  • Gender:Male
  • Location:A strange world where water falls out of the sky... for no reason.
  • Interests:Graphic Design, Coding, Splinter Cell, Cats

Posted 14 May 2007 - 09:31 PM

The first three lines are telling you the attempted accesses. 401 is the HTTP protocol for 'Authorization Needed' basically. Its also stating the type of request (GET), and the HTTP version (1.1).

The last line is the 200 protocol, which is a successful request, and it looks like it was able to load the style sheet, probably for a 'Invalid Access' page or something.

When using HTTP authorization, when you input an invalid username/password combination, it will keep sending the request for the access until you either get it correct and it can let you through to the actual page, or you press 'Cancel' and it gives you a 'Cannot Access' error code (HTTP protocol 403).

All I can say, is either double check your details and make sure they are 100% accurate with the details you gave PHPMyAdmin, or simply use another method.

#3 U1

    Young Padawan

  • Members
  • Pip
  • 245 posts

Posted 15 May 2007 - 12:46 PM

If im right, i can't remember but the .htaccess in windows has to be named ht.acl or ".htaccess" with the quotes for it to work., WAMP may be different i only ever used xammp.

Edited by Unknown1, 15 May 2007 - 12:46 PM.


#4 Chris.

    Young Padawan

  • Members
  • Pip
  • 129 posts
  • Gender:Male

Posted 15 May 2007 - 02:08 PM

I'm not using htaccess. It is the built in PhpMyAdmin login thing.

#5 _*Creative Insanity_*

  • Guests

Posted 15 May 2007 - 03:43 PM

I am sure that phpmyadmin gets the login info from the sql database from the users table. Damn sure actually.

#6 Chris.

    Young Padawan

  • Members
  • Pip
  • 129 posts
  • Gender:Male

Posted 15 May 2007 - 05:07 PM

You change your username and password in the config.inc.php file for PhpMyAdmin.

#7 _*Creative Insanity_*

  • Guests

Posted 15 May 2007 - 05:40 PM

Yeah but that has to match what is in the sql table or it will not work.

You can set the root password by opening up command and then type (if no password is set):
mysql (enter)

use mysql; (enter)

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password'); (enter)

Then add that password and user name to the phpmyadmin config file and walla!

Edited by Creative Insanity, 15 May 2007 - 05:40 PM.


#8 Chris.

    Young Padawan

  • Members
  • Pip
  • 129 posts
  • Gender:Male

Posted 15 May 2007 - 07:51 PM

So, what you are saying is the password for the database has to be the same as the password in the config.inc.php file?

Edit: Yeah, that is what you are saying. Dude, you are a beast. Thanks!

Edited by Chris., 15 May 2007 - 07:53 PM.






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users