How to set up: Auto log-in PHP-myAdmin
Posted by: johnyct9760 (---.hsd1.mi.comcast.net)
Date: February 11, 2009 04:05PM

I tryed to add this code to my config.ini.php file within my PHP-MyAdmin folder

Or, if you prefer to not be prompted every time you log in:

<?php
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'my_pass_goes_here';
?>

That code come from this link:
[www.phpmyadmin.net]

But sadly it didn't take yawning smiley( still getting prompted to enter my root and pass every time I turn on PHP-MyAdmin

Just to put it in context let me share my full config.ini.php code what ya:
LOCATION: C:\wamp\apps\phpmyadmin3.1.1\config.ini.php

-CODE-
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.1.1 setup script by Michal Čihař <michal@cihar.com>
* Version: $Id: setup.php 10748 2007-10-10 07:30:59Z cybot_tm $
* Date: Wed, 11 Feb 2009 09:24:08 GMT
*/

/* Servers configuration */
$i = 0;

/* Server localhost (cookie) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/*Newly added code:*/
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'my_pass_goes_here';


/* End of servers configuration */

$cfg['blowfish_secret'] = '***************';
?>
-END CODE-

Thx for the assist everyone!

John



Edited 3 time(s). Last edit at 02/11/2009 04:11PM by johnyct9760.

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: February 11, 2009 04:13PM

clear out the blowfish

$cfg['blowfish_secret'] = '';

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: johnyct9760 (---.hsd1.mi.comcast.net)
Date: February 11, 2009 08:20PM

Thx for the reply Steve sadly that didn't do the trick when I commented out the the blowfish line it got rid of the remembered longin "root" and my password. I have had to re-type it every time I opened PHP-Myadmin. Got any other ideas?

Thx for the continued help and support!

JT



Edited 1 time(s). Last edit at 02/11/2009 08:21PM by johnyct9760.

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: February 11, 2009 08:23PM

send me ur entire config file to gmail email below

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: johnyct9760 (---.hsd1.mi.comcast.net)
Date: February 12, 2009 04:14PM

Ok I just sent you an email for:

Johnyct9760@hotmail.com

It has a copy of my config.ini.php file attached with the email hopefully it doesn't get bounded to your junk mail folder.

In case it does I have offered a link to a direct download off my server space:

[www.johncliffordtaylor.com]

Once again thank you for all your help Steven I really appreciate it a lot.

John Taylor

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: yfastud (Moderator)
Date: February 12, 2009 06:27PM

auto login only for you or any time open phpmyadmin?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

SOLVED: How to set up: Auto log-in PHP-myAdmin
Posted by: johnyct9760 (---.hsd1.mi.comcast.net)
Date: February 13, 2009 12:33AM

I have the updated config.ini.php code right here it works just fine for log in and auto-log in.

<?php
/* Servers configuration */
$i = 0;
/* Server localhost (cookie) [1] */
$cfg['blowfish_secret'] = '';
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'placeYourPassWordHere';
/* End of servers configuration */
?>

I just saved that code as: config.ini.php in the:
C:\wamp\apps\phpmyadmin3.1.1
File directory and then I can log in with out having to manually type in my root and pass. Or even press the GO button from log-in screen (yep I'm pretty lazy) But any way I hope this code help Big thx you to Steven Martin for all his assistance on this post.

Take it easy and thx for all the help and feedback!

John

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: yfastud (Moderator)
Date: February 13, 2009 02:12AM

huh?
the default is config and you changed all things around then finally change back to default???

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: stevenmartin99 (193.120.116.---)
Date: February 13, 2009 06:31AM

yes i thnought so too yfastud .. He sent me the file. But it was actuaclly the sample config file which he was changing in case soomething went wrong. And thnat has coookie .

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: johnyct9760 (---.hsd1.mi.comcast.net)
Date: February 13, 2009 04:17PM

Yep I'm like a babe in the woods on this kind of stuff, but from what I was able to gather this is:

$cfg['Servers'][$i]['auth_type'] = 'config'; /*<--That is auto log-in */

vs.

$cfg['Servers'][$i]['auth_type'] = 'cookie'; /*<--That is manually log-in */

I also moved changed:

$cfg['blowfish_secret'] = '***************';

to

$cfg['blowfish_secret'] = '';

And moved it up under the:


$i = 0;

Line of code.

-CODE-

$i = 0;
/* Server localhost (cookie) [1] */
$cfg['blowfish_secret'] = '';
$i++;

-END OF CODE-

I'm not really to sure what that is all doing. I get the cookie vs. config part but if any one could shed some light on the whole $cfg['blowfish... line and what it does then that would be very cool.

Thank you for the help

John



Edited 1 time(s). Last edit at 02/13/2009 04:18PM by johnyct9760.

Re: How to set up: Auto log-in PHP-myAdmin
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: February 13, 2009 05:03PM

Blowfish is a type of encyption. you type anything you want in there,,,


then wen u keep in ur password into the box the blowfish encytion modifys the password using an alogrythm so that it is more secure and then compares it against mysqls password..


you can only use blowfish with cookie.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Sorry, only registered users may post in this forum.