config.inc.php flie missing in phpMyAdmin 2.7

[Steven Barkess]

Hi

 

Perhaps someone using 1and1 can help....

 

Setting up phpMyAdmin for your MySQL database

 

3. Once you have downloaded the file unzip it using WinZip or any way you prefer. The files will then be placed into a directory called phpMyAdmin. Within this directory there is a file called config.inc.php.

 

I've download v2.7, in the above guide it talks about v2.3. Any way, within 2.7, I cannot find the file config.inc.php

 

Has this been removed from the later version, any next steps appreciated.

 

Thanks

 

Steven

[AlanR]

There is no config.inc.php file supplied with 2.7.0. You're to build your own by copying the relevant lines from config.default.php. You only need a few lines, anything omitted in your config.inc defaults to the the settings in config.default.php

 

Do you need an example?

[Steven Barkess]

Hi Alan

 

Yes please.

 

Been using Actinic for the last two years and this is all new to me. Appreciate an example.

 

Steven

[AlanR]

I simply copied the top section from an older installation's config.inc.php

 

<?php

/* $Id: config.inc.php,v 2.5.2.1 2004/02/15 01:18:52 rabus Exp $ */

// vim: expandtab sw=4 ts=4 sts=4:

 

/**

* phpMyAdmin Configuration File

*

* All directives are explained in Documentation.html

*/

 

 

/**

* Your phpMyAdmin url

*

* Complete the variable below with the full url ie

* http://www.your_web.net/path_to_your_phpMyAdmin_directory/

*

* It must contain characters that are valid for a URL, and the path is

* case sensitive on some Web servers, for example Unix-based servers.

*

* In most cases you can leave this variable empty, as the correct value

* will be detected automatically. However, we recommend that you do

* test to see that the auto-detection code works in your system. A good

* test is to browse a table, then edit a row and save it. There will be

* an error message if phpMyAdmin cannot auto-detect the correct value.

*

* If the auto-detection code does work properly, you can set to TRUE the

* $cfg['PmaAbsoluteUri_DisableWarning'] variable below.

*/

$cfg['PmaAbsoluteUri'] = 'XXXXX'; // You can leave this blank ( '' )

// or put in your url ie: http://www.domain.com/phpMyAdmin-2.7.0

 

 

/**

* Disable the default warning about $cfg['PmaAbsoluteUri'] not being set

* You should use this if and ONLY if the PmaAbsoluteUri auto-detection

* works perfectly.

*/

 

 

/**

* Server(s) configuration

*/

$i = 0;

// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].

// You can disable a server config entry by setting host to ''.

$i++;

$cfg['Servers'][$i]['host'] = 'your_db_server_name'; // MySQL hostname or IP address

$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port

$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket

$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')

$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection

// (requires PHP >= 4.3.0)

$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings

// (this user must have read-only

$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"

// and "mysql/db" tables).

// The controluser is also

// used for all relational

// features (pmadb)

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?

$cfg['Servers'][$i]['user'] = 'your_db_user_name'; // MySQL user

$cfg['Servers'][$i]['password'] = 'your_db_password'; // MySQL password (only needed

// with 'config' auth_type)

$cfg['Servers'][$i]['only_db'] = 'your_database's_name'; // If set to a db-name, only

// this db is displayed in left frame

// It may also be an array of db-names, where sorting order is relevant.

$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname

 

$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features

// (see scripts/create_tables.sql)

// - leave blank for no support

// DEFAULT: 'phpmyadmin'

$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table

// - leave blank for no bookmark support

// DEFAULT: 'pma_bookmark'

$cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc)

// - leave blank for no relation-links support

// DEFAULT: 'pma_relation'

$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields

// - leave blank for no display fields support

// DEFAULT: 'pma_table_info'

$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema

// - leave blank for no PDF schema support

// DEFAULT: 'pma_table_coords'

$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf

// - leave blank if you don't want to use this

// DEFAULT: 'pma_pdf_pages'

$cfg['Servers'][$i]['column_info'] = ''; // table to store column information

// - leave blank for no column comments/mime types

// DEFAULT: 'pma_column_info'

$cfg['Servers'][$i]['history'] = ''; // table to store SQL history

// - leave blank for no SQL query history

// DEFAULT: 'pma_history'

$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables

// are up to date. This prevents compatibility

// checks and thereby increases performance.

$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use

= '';

$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults

= array();

 

// You only need the lines below if you want to add more databases as choices. See default line above.

 

$i++;

$cfg['Servers'][$i]['host'] = '';

$cfg['Servers'][$i]['port'] = '';

$cfg['Servers'][$i]['socket'] = '';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = FALSE;

$cfg['Servers'][$i]['controluser'] = '';

$cfg['Servers'][$i]['controlpass'] = '';

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['only_db'] = '';

$cfg['Servers'][$i]['verbose'] = '';

$cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql

$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]['verbose_check'] = TRUE;

$cfg['Servers'][$i]['AllowDeny']['order']

= '';

$cfg['Servers'][$i]['AllowDeny']['rules']

= array();

 

$i++;

$cfg['Servers'][$i]['host'] = '';

$cfg['Servers'][$i]['port'] = '';

$cfg['Servers'][$i]['socket'] = '';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = FALSE;

$cfg['Servers'][$i]['controluser'] = '';

$cfg['Servers'][$i]['controlpass'] = '';

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['only_db'] = '';

$cfg['Servers'][$i]['verbose'] = '';

$cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql

$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]['verbose_check'] = TRUE;

$cfg['Servers'][$i]['AllowDeny']['order']

= '';

$cfg['Servers'][$i]['AllowDeny']['rules']

= array();

 

// If you have more than one server configured, you can set $cfg['ServerDefault']

// to any one of them to autoconnect to that server when phpMyAdmin is started,

// or set it to 0 to be given a list of servers without logging in

// If you have only one server configured, $cfg['ServerDefault'] *MUST* be

// set to that server.

$cfg['ServerDefault'] = 1; // Default server (0 = no default server)

$cfg['Server'] = '';

unset($cfg['Servers'][0]);

 

?>

[Steven Barkess]

Thanks, makes sense. Steven

[AlanR]

You could basically strip it right down to these few lines since everything not defined here is in the default file but I like to have the other stuff visible.

 

<?php

 

/* $Id: config.inc.php,v 2.5.2.1 2004/02/15 01:18:52 rabus Exp $ */

// vim: expandtab sw=4 ts=4 sts=4:

 

/**

* phpMyAdmin Configuration File

*

* All directives are explained in Documentation.html

*/

 

 

$cfg['PmaAbsoluteUri'] = 'XXXXX'; // You can leave this blank ( '' )

// or put in your url ie: http://www.domain.com/phpMyAdmin-2.7.0

 

$cfg['Servers'][$i]['host'] = 'your_db_server_name'; // MySQL hostname or IP address

 

$cfg['Servers'][$i]['user'] = 'your_db_user_name'; // MySQL user

 

$cfg['Servers'][$i]['password'] = 'your_db_password'; // MySQL password (only needed

// with 'config' auth_type)

 

$cfg['Servers'][$i]['only_db'] = 'your_database's_name'; // If set to a db-name, only

// this db is displayed in left frame

 

?>

[AlanR]

1&1 does have phpMyAdmin available from the control panel. They haven't updated to 2.7.0 yet though.

 

Check MySQL Administration.

[Steven Barkess]

Hi

 

So it does. I set up the db last night within 1&1 and then checking this morning it has additional options including phpMyAdmin.

 

I've printed out the instal guide so should be able to follow next steps now. Waiting for my domain name to be transfered in then happy days.

 

Steven