How to enable the login portal to phpmyadmin on xampplite?
Posted: 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).
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?
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';