Showing posts with label config. Show all posts
Showing posts with label config. Show all posts

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;