dahwan Posted December 31, 2006 Share Posted December 31, 2006 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.jpgThanks Quote Link to comment https://forums.phpfreaks.com/topic/32402-solved-phpmyadmin-users/ Share on other sites More sharing options...
wildteen88 Posted December 31, 2006 Share Posted December 31, 2006 You'll want to change phpMyAdmins configuration. Go to where you installed phpMyAdmin and look for a file called config.ic.phpopen 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. Quote Link to comment https://forums.phpfreaks.com/topic/32402-solved-phpmyadmin-users/#findComment-150506 Share on other sites More sharing options...
dahwan Posted December 31, 2006 Author Share Posted December 31, 2006 allmost...http://i76.photobucket.com/albums/j37/dahwan/PHPmyADMIN-1.jpgStill doesnt work Quote Link to comment https://forums.phpfreaks.com/topic/32402-solved-phpmyadmin-users/#findComment-150515 Share on other sites More sharing options...
wildteen88 Posted December 31, 2006 Share Posted December 31, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/32402-solved-phpmyadmin-users/#findComment-150535 Share on other sites More sharing options...
dahwan Posted December 31, 2006 Author Share Posted December 31, 2006 thx! Quote Link to comment https://forums.phpfreaks.com/topic/32402-solved-phpmyadmin-users/#findComment-150549 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.