Apache Friends Support Forum

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';

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

Thank you so much! 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.