February 18, 2014

Remove login from phpmyadmin in wamp server or disable admin login in mysql

Get rid of phpmyadmin login 

If you want to use phpmyadmin without cookie limit and want to get rid of login credentials.

Heres is the tip for those:

Go to the wamp installation directory

C:\wamp\apps\phpmyadmin** 

** version numbers that may be different.

Find the config.inc.php and take back up of it to save for the future use.

Open config.inc.php in any text editor (i.e. notepad, notepad++)

Go to the authentication section type.
/* Authentication type */
You will find the $cfg array(mostly 3 dimensional array.).

Do change as follows:
Change the auth type value to config.
                     // $cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['auth_type'] = 'config';

Now speciy the user and password for same like below:

Add the following lines/params in /*Server parameters section*/ which is generally next to authentication type:

$cfg['Servers'][$i]['user'] = 'root';
  /*User name during installation*/
$cfg['Servers'][$i]['password'] = ' ';           /*Password during installtion generally blank*/
$cfg['Servers'][$i]['AllowRoot'] = TRUE;   

No comments:

Post a Comment

Thank you very much for your comment.
Your message has been successfully sent out to author of this blog.