phpadmin的配制的困惑

blueriver · 发表于 2003-5-14 14:07:57

我是redhat8.0,装了phpmyadmin -2.50-rc1
$cfg['PmaAbsoluteUri'] = '';-----------怎么配制?
$cfg['Servers'][$i]['host']       = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['port']       = '';
$cfg['Servers'][$i]['auth_type']    = 'http';
$cfg['Servers'][$i]['user']       = 'root';    // MySQL user
$cfg['Servers'][$i]['password']    = 'fsdfsfs';
上面这样配制可以吗?

我能连接http://xxx/phpadmin/
进去了,提示错误
----------------------------------------------------------------------------------------------
必须在您的配置文件中设定 $cfg['PmaAbsoluteUri'] 指令!
-----------------------------------------------------------------------------------------------

下方有:
------------------------------------------------------------------------
错误
使用链接表的额外特性尚未激活。要查出原因，请单击此处。
-------------------------------------------------------------------------

点记"此处"-进去了,提示 :
-------------------------------------
数据库 nuke  运行于 localhost
PMA Database ... 不好[ 文档 ]
一般关系特性已禁用
--------------------------------------

redhat71 · 发表于 2003-5-14 17:55:53

每行后面都有注释信息，看完了再折腾不是更省事？！

好象这个
// MySQL password (only needed
// with 'config' auth_type)
写的很清楚了，只有上面的auth_type设置为config，才需要直接在这个文件里设置用户和密码
你上面设成http，下面又设用户密码。。。

$cfg['PmaAbsoluteUri']
这个就更清楚了，就在它上面的注释里有现成的例子：
/**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
* http://www.your_web.net/path_to_your_phpMyAdmin_directory/

照你上面说的，你给它这行就完了
$cfg['PmaAbsoluteUri'] = ''http://xxx/phpadmin/ ';

看清楚再动手，是一种乐趣。。。

blueriver · 发表于 2003-5-14 18:30:28

--呵呵,不好意思,可能我的意思可能表达不是很明白
---------------------好象这个
// MySQL password (only needed
// with 'config' auth_type)
写的很清楚了，只有上面的auth_type设置为config，才需要直接在这个文件里设置用户和密码
你上面设成http，下面又设用户密码。。。

---------------------这样也能连接,用浏览器连接时输入用户名和密码就能进去了,我的主要问题是.
..错误
使用链接表的额外特性尚未激活。要查出原因，请单击此处。
-------------------------------------------------------------------------

点记"此处"-进去了,提示 :
-------------------------------------
数据库 nuke 运行于 localhost
PMA Database ... 不好[ 文档 ]
一般关系特性已禁用
谢谢你

redhat71 · 发表于 2003-5-14 18:38:01

唉。。。因为你已经设置了HTTP的AUTH＿TYPE，它根本就不理会下面设置的用户和密码了！

你是能用，但你就不想想为什么你已经设置了用户密码，怎么调用的时候还要你再输入呢？

‘额外特性’那个错误我没见过

‘...不好[文档]’这部分是什么意思？你省略了原文？

redhat71 · 发表于 2003-5-14 18:41:21

如果你不怕麻烦的话，用英文语言进去，把详细的错误提示贴上或发给我，截图也行

我可以帮你看看，不过不要指望我一定能看懂
我和你一样菜，只是喜欢看文档，用GOOGLE。。。

blueriver · 发表于 2003-5-14 18:54:08

[code:1]Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.
只要点记了here
PMA Database ... not OK[ Documentation ]---不是省略的,上面就这样显示
General relation features Disabled

[/code:1]

blueriver · 发表于 2003-5-14 18:57:09

我马上就贴我的config出来[/code]

blueriver · 发表于 2003-5-14 19:03:56

[/code]<?php
/* $Id: config.inc.php,v 1.174 2003/04/11 11:59:27 nijel 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://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'] = 'http://xxxx.3322.org/phpadmin/';

/**
* 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;

/**
* 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
$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)
$cfg['Servers'][$i]['auth_type']    = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']       = 'root';    // MySQL user
$cfg['Servers'][$i]['password']    = 'gddgdf';       // MySQL password (only needed
                                                // with 'config' auth_type)
$cfg['Servers'][$i]['only_db']    = '';       // If set to a db-name, only
                                                // this db is displayed
                                                // at left frame
                                                // It may also be an array
                                                // of db-names
$cfg['Servers'][$i]['verbose']    = '';       // Verbose name for this host - leave blank to show the hostname

blueriver · 发表于 2003-5-14 19:05:59

//    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']          = '';
$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_page'
$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();

blueriver · 发表于 2003-5-14 19:08:48

下面的肯定没该过的

redhat71 · 发表于 2003-5-14 19:19:13

好象是有参数没设置正确，我对PHP和MYSQL也只是装上能用这个程度（基本上都是默认值），帮不了你

这是我在USENET查到的一个贴，有人问过同样的问题，给出的回答也是文档。。。

From: Stephen Tiano ([email protected])
Subject: phpMyAdmin

View this article only
Newsgroups: mailing.database.mysql
Date: 2003-03-08 12:29:14 PST

--Boundary_(ID_W3pCQ6B77xfNe928V1XZ9w)
Content-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT

Anyone familiar with the GUI interface for MySQL/PHP called 'phpMyAdmin'?

I'm at a point in my intensive self-study via books, tutorials, and
exercises where one of the books I'm working with--trying to tie
together with my graphical HTML editor--Dreamweaver: PHP
Development--suggests phpMyAdmin is worth knowing as a tool for more
efficient work in a production environment.

When I get phpMyAdmin to show up in my browser, it looks pretty much the
way the book shows it. Except that, after a few lines that are
word-for-word with the book, in place of

[bullet] Run SQL query/queries on ...

and a flexible field in which to type in said queries, I have an error
message:

[bullet] Error
         The additional Features for working with linked Tables have
            been deactivated.
         To find out why, click here.

Clicking 'here' brings me to a link to 'Documentation' and a line
underneath saying 'General relation features Disabled'. Clicking on
'Documentation' brings me to what looks vaguely like directions for
altering various '$cfg' strings.

Needless to say, I'm leery. I'm not certain where to find these strings
to alter. But more importantly, I'm not clear on what I'm being told to
do. It's not as if the directions are step-by-step for a novice. And it
doesn't spell out whether this will address the 'General features' being
'Disabled'. That is, will it make these 'General features' functional?

May I ask your help in doping this out?

Thank you.

Steve Tiano

--Boundary_(ID_W3pCQ6B77xfNe928V1XZ9w)--

Message 27 in thread
From: "Barry Marler" ([email protected])
Subject: RE: phpMyAdmin

View this article only
Newsgroups: mailing.database.mysql
Date: 2003-03-08 13:33:07 PST

Open http://your.server.name/phpMyAdmin-2.*.*/Documentation.html#setup.  If
you read the docs (#3 in the initial "Quick Install" section tells you that
the file you'll be editing is config.inc.php, in the phpMyAdmin root dir),
you'll just be stepped through a simple series of table creations and
editing of config.inc.php (which is trivial).

redhat71 · 发表于 2003-5-14 19:39:34

看了你的配置，和我的差不多，没看出什么问题

问问版主有没有懂MYSQL的吧，PMA只是个WEB方式的CLIENT
如果问题出在MYSQL的设置上，研究PMA也没什么用

blueriver · 发表于 2003-5-14 19:44:41

不管怎么说,都要感谢您

gxingx2000 · 发表于 2003-5-15 09:11:11

我也遇到了同样的问题

是不是你的mysql或php 插件没有装全

我在win2k下apache+mysql+php这样配置使用很正常的

ufome · 发表于 2003-5-15 10:10:33

$cfg['PmaAbsoluteUri'] = http://用ip试试/phpmyadmin

		自动登录	找回密码
密码			注册