How to enable the login portal to phpmyadmin on xampplite?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to enable the login portal to phpmyadmin on xampplite?

Postby Znote » 06. January 2010 17:07

Greetings. ^^

I am using xampplite, I don't need all the things xampp comes with, so the lite version should do.

However, if I shall login to phpmyadmin, I have to write down my username and password in a config file, named:
config.inc.php with this contents (Sensitive Information is sensured by stars).

Code: Select all
<?php
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = '********'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type']            = 'config';
$cfg['Servers'][$i]['user']                 = '********';
$cfg['Servers'][$i]['password']             = '********';
$cfg['Servers'][$i]['AllowNoPassword']      = true;

/* Server parameters */
$cfg['Servers'][$i]['host']             = 'localhost';
$cfg['Servers'][$i]['connect_type']     = 'tcp';
$cfg['Servers'][$i]['compress']         = false;

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = '********';
$cfg['Servers'][$i]['controlpass'] = '********';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb']            = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable']    = 'pma_bookmark';
$cfg['Servers'][$i]['relation']         = 'pma_relation';
$cfg['Servers'][$i]['table_info']       = 'pma_table_info';
$cfg['Servers'][$i]['table_coords']     = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages']        = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info']      = 'pma_column_info';
$cfg['Servers'][$i]['history']          = 'pma_history';
$cfg['Servers'][$i]['designer_coords']  = 'pma_designer_coords';

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir']   = '';
$cfg['SaveDir']     = '';

$cfg['AllowAnywhereRecoding']       = true;
$cfg['DefaultCharset']              = 'utf-8';
$cfg['DefaultLang']                 = 'en-utf-8';
$cfg['DefaultConnectionCollation']  = 'utf8_general_ci';

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.1/en';
$cfg['MySQLManualType'] = 'searchable';

?>


The problem is, no matter where I am, if I type the address to phpmyadmin, I will login with the username and password written in this config.inc.php file.

I remember before, when I entered the url to phpmyadmin, I had to write in username and password there and then login to my sql user account.

What I want is to be able to login with separate accounts. With unique passwords. So I can share the link with friends without having them to use my administrator account.

Just a thought I had, perhaps I have to change the authentication type to web or something, to make it work like an online login portal?
Code: Select all
$cfg['Servers'][$i]['auth_type']            = 'config';
Znote
 
Posts: 20
Joined: 17. November 2008 18:15

Re: How to enable the login portal to phpmyadmin on xampplite?

Postby Wiedmann » 06. January 2010 17:13

What I want is to be able to login with separate accounts. With unique passwords.

You have to change this line:
Code: Select all
$cfg['Servers'][$i]['auth_type']            = 'config';

--> http://wiki.phpmyadmin.net/pma/auth_types
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: How to enable the login portal to phpmyadmin on xampplite?

Postby Znote » 06. January 2010 17:59

Thank you so much! :D My thoughts were correct, I just forgot about the two extra values "cookie" and "http".

It should be listed the alternatives in the config file. There is already very much info there, why not squeeze in 1 extra sentence to help mega-noobs. :D
Znote
 
Posts: 20
Joined: 17. November 2008 18:15


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests