Resolved phpMyAdmin config.inc.php missing

[synec]

Im running Plesk 8.1 on a Suse 10.1 installation.
I've lost my config.inc.php - somehow
I did not delete, but its missing.

PLEASE !!! PASTE YOUR config.inc.php
from /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin WITHOUT YOUR LOGINS here for me as a template for reconstruction

 

[nullbarriere]

config.inc.php lost and found

the problem
i had the same or like problem more than once

so here, for the public, and for me in the future, my semi-professional solution

i startet assuming something's wrong, when trying to invoke phpmyadmin from the plesk desktop (my -german- button says 'DB WebAdmin')

the popup window looks like:
Access denied for user 'pma_wYxxxxxxxMP'@'localhost' (using password: YES)

the solution I

here helps the swsoft knowlegdbase article #1252: http://kb.swsoft.com/article_16_1252_en.html

basically is suggested to do plesks work by adding the plesk controluser to the mysql.user table - the plek controluser is used by invoking phpmyadmin from the plesk desktop

this works fine, but you need config.inc.php for username (something like 'pma_wYxxxxxxxMP') and password of the controluser

the big trouble
!!now you are in big trouble: config.inc.php is missing!!

the solution II
you can restore it quite easily: usually config.inc.php would be in directory /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin

when its missing there should still be config.inc.php.old, which is quite good xept for the login data of the controluser

now the lost and found part:

there is a config.default.php in directory /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries which contains the right username/password (better check it against the above mentioned access denied error message)

taraaah:

just copy config.inc.php.old to config.inc.php, copy'n paste the login data from config.default.php to your new config.inc.php and follow the easy steps from KB #1252.

Happy phping

 

[Ross M]

I have mine set to no login required, as I password protect my directory. Here's what I have.

<?php

/* $Id: config.sample.inc.php 9689 2006-11-10 20:05:49Z nijel $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use scripts/setup.php
 *
 * All directives are explained in Documentation.html and on phpMyAdmin
 * wiki <[url]http://wiki.cihar.com[/url]>.
 */

$i=0;
$i++;
$cfg['Servers'][$i]['user']          = 'user';
$cfg['Servers'][$i]['password']      = 'pass'; // use here your password

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

/* 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'] = 'mysql';
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* 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'] = '';

?>

 

[danallen1]

Ok for the solutions here but why is config.inc.php disappearing? That is not good.

 

[chirag prajapati]

Nice solution when i set host name "localhost" and user name and password of mysql its work for me thanks