[SOLVED] PHPmyAdmin users

[dahwan]

Hi. I created a new user on phpmyadmin, so now i have my new user and the root user. i took away all privileges from the root user, and now i realised i dont know how to logg in with my new user. i know the username and password, all i need is to know how to logg in with a diffrent user.

http://i76.photobucket.com/albums/j37/dahwan/PHPmyADMIN.jpg

Thanks

[wildteen88]

You'll want to change phpMyAdmins configuration. Go to where you installed phpMyAdmin and look for a file called config.ic.php

open that up for editing in notepad or whatever and look for the following line:
[code]$cfg['Servers'][$i]['auth_type']    = 'config';    // Authentication method (config, http or cookie based)?[/code]
Change config to cookie instead.

Save config.inc.php. Now go back to phpMyAdmin. You should be faced with a login box now. Enter the username and password credentials for the user you want to login to. If you dont clear any cookies for localhost. The login box should now appear.

Also keep the root user as-is dont change anythink. Do what phpMyAdmin says and give the root user a password.

[dahwan]

allmost...

http://i76.photobucket.com/albums/j37/dahwan/PHPmyADMIN-1.jpg

Still doesnt work

[wildteen88]

Oh yeah fogot about that. re-open up the config.inc.php file and find the following line:
[code=php:0]$cfg['blowfish_secret'] = '';[/code]


add a secret passphrase between the two quotes like so:
$cfg['blowfish_secret'] = 'pasePhraseHere';

Save the config.inc.php and relaunch phpMyAdmin a login box should now appear.

[dahwan]

thx!