Установка phpMyAdmin

[сандро]

Скжите, что ясделал не так и что ещ нужно куда вписать. Вот, фрагмент, конфига phpMyAdmin а. Что сюда еще нужно вписать

 

<?php

/* $Id: config.inc.php,v 2.3 2003/12/02 21:59:24 lem9 Exp $ */

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

 

/**

* phpMyAdmin Configuration File

*

* All directives are explained in Documentation.html

*/

 

 

/**

* Sets the php error reporting - Please do not change this line!

*/

if (!isset($old_error_reporting)) {

error_reporting(E_ALL);

@ini_set('display_errors', '1');

}

 

 

/**

* Your phpMyAdmin url

*

* Complete the variable below with the full url ie

* http://trains.org.ua/phpMyAdmin/

*

* 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'] = 'http://trains.org.ua/phpMyAdmin/index.php';

 

 

/**

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

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

* works perfectly.

*/

$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;

 

/**

* Disable the default warning that is displayed on the DB Details Structure page if

* any of the required Tables for the relationfeatures could not be found

*/

$cfg['PmaNoRelation_DisableWarning'] = FALSE;

 

/**

* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If

* at least one server configuration uses 'cookie' auth_type, enter here a

* passphrase that will be used by blowfish.

*/

$cfg['blowfish_secret'] = '123456789';

 

/**

* 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'] = 'localhost'; // 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'] = 'snadro'; // 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'] = 'sandro'; // MySQL user

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

// with 'config' auth_type)

$cfg['Servers'][$i]['only_db'] = ''; // 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();

 

 

$i++;

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

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

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

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

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

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

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

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

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

$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'] = 'localhost';

$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'] = 'sandro';

$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();

 

чтобы не было: Сервер localhost

Ошибка

 

Ответ MySQL:

 

 

#1045 - Access denied for user: 'snadro@localhost' (Using password: YES)

 

[Документация]

 

p.s. пароли везде правильные стоят, так как сними, только что я ставил форум.

[Остап]

сандро

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

for user: 'snadro@localhost'

 

Не в разных ли юзерах ?

[сандро]

http://trains.org.ua/forums/screenshots/phpMyAdmin.jpg

Не в разных ли юзерах ? 

Это, я только, что подправил, теперь он завелся, но при выборе базы, идет как бы постянная перзагрузка страницы. Внизу, окна брузера, постоянно бегает строчка с какими то путями к чему то, я не разберу. В итоге, стоит выбрать базу, я никуда не попадаю.