Chinaunix

标题: [求助]关于phpadmin设置的问题,小弟跪求答案! [打印本页]

作者: 堕落的人生 时间: 2004-08-10 20:44
标题: [求助]关于phpadmin设置的问题,小弟跪求答案!
网站是网上空间商提供的现在出现了这样的情况
PMA Database ... 不好[ 文档 ]
一般关系特性已禁用

我在论坛上也看到了一些别的文章，我用phpMyAdmin自带的create_tables.sql试了一下出现了以下的情况
错误

SQL 查询 :

-- ########################################################
-- #
-- SQL Commands to set up the pmadb as described in #
-- Documentation.txt. #
-- #
-- This script expects the user pma to already be #
-- existing. (if we would put a line here to create him #
-- too many users might just use this script and end #
-- up with having the same password for the controluser) #
-- #
-- This user "pma" must be defined in config.inc.php #
-- (controluser/controlpass) #
-- #
-- Please dont forget to set up the tablenames in #
-- config.inc.php #
-- #
-- Please note that the table names might be converted #
-- to lower case, if the MySQL option #
-- "lower_case_table_names" is enabled. By default, this #
-- is the case on Win32 machines. #
-- #
-- ########################################################
DROP DATABASE IF EXISTS `phpmyadmin` ;

CREATE DATABASE IF NOT EXISTS `phpmyadmin` ;

-- (backquotes are not supported in USE)
USE phpmyadmin;

GRANT SELECT ,
INSERT ,

DELETE ,
UPDATE ON `phpmyadmin` . * TO 'pma'@localhost ;

DROP TABLE IF EXISTS `pma_bookmark` ;

CREATE TABLE `pma_bookmark` (

`id` int( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`dbase` VARCHAR( 255 ) NOT NULL ,
`user` VARCHAR( 255 ) NOT NULL ,
`label` VARCHAR( 255 ) NOT NULL ,
`query` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM COMMENT = 'Bookmarks';

DROP TABLE IF EXISTS `pma_relation` ;

CREATE TABLE `pma_relation` (
`master_db` VARCHAR( 64 ) NOT NULL DEFAULT '',
`master_table` VARCHAR( 64 ) NOT NULL DEFAULT '',
`master_field` VARCHAR( 64 ) NOT NULL DEFAULT '',
`foreign_db` VARCHAR( 64 ) NOT NULL DEFAULT '',
`foreign_table` VARCHAR( 64 ) NOT NULL DEFAULT '',
`foreign_field` VARCHAR( 64 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `master_db` , `master_table` , `master_field` ) ,
KEY `foreign_field` ( `foreign_db` , `foreign_table` )
) TYPE = MYISAM COMMENT = 'Relation table';

DROP TABLE IF EXISTS `pma_table_info` ;

CREATE TABLE `pma_table_info` (
`db_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`table_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`display_field` VARCHAR( 64 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `db_name` , `table_name` )
) TYPE = MYISAM COMMENT = 'Table information for phpMyAdmin';

DROP TABLE IF EXISTS `pma_table_coords` ;

CREATE TABLE `pma_table_coords` (
`db_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`table_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`pdf_page_number` INT NOT NULL DEFAULT '0',
`x` float unsigned NOT NULL DEFAULT '0',
`y` float unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ( `db_name` , `table_name` , `pdf_page_number` )
) TYPE = MYISAM COMMENT = 'Table coordinates for phpMyAdmin PDF output';

DROP TABLE IF EXISTS `pma_pdf_pages` ;

CREATE TABLE `pma_pdf_pages` (
`db_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`page_nr` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`page_descr` VARCHAR( 50 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `page_nr` ) ,
KEY ( `db_name` )
) TYPE = MYISAM COMMENT = 'PDF Relationpages for PMA';

DROP TABLE IF EXISTS `pma_column_info` ;

CREATE TABLE `pma_column_info` (
`id` INT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`db_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`table_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`column_name` VARCHAR( 64 ) NOT NULL DEFAULT '',
`comment` VARCHAR( 255 ) NOT NULL DEFAULT '',
`mimetype` VARCHAR( 255 ) NOT NULL DEFAULT '',
`transformation` VARCHAR( 255 ) NOT NULL DEFAULT '',
`transformation_options` VARCHAR( 255 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `db_name` ( `db_name` , `table_name` , `column_name` )
) TYPE = MYISAM COMMENT = 'Column Information for phpMyAdmin';

DROP TABLE IF EXISTS `pma_history` ;

CREATE TABLE `pma_history` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 64 ) NOT NULL ,
`db` VARCHAR( 64 ) NOT NULL ,
`table` VARCHAR( 64 ) NOT NULL ,
`timevalue` TIMESTAMP NOT NULL ,
`sqlquery` TEXT NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `username` ( `username` , `db` , `table` , `timevalue` )
) TYPE = MYISAM COMMENT = 'SQL history';

MySQL 返回:

已经禁用“DROP DATABASE”语句。

[文档] · [返回]

还有我人为手工修改后出现的是这样的情况

$cfg['Servers'][$i]['pmadb'] ...  不好 [ 文档 ]

$cfg['Servers'][$i]['relation'] ...  不好 [ 文档 ]
一般关系特性: 已禁用

$cfg['Servers'][$i]['table_info'] ...  不好 [ 文档 ]
显示特性: 已禁用

$cfg['Servers'][$i]['table_coords'] ...  不好 [ 文档 ]
$cfg['Servers'][$i]['pdf_pages'] ...  不好 [ 文档 ]
创建 PDF: 已禁用

$cfg['Servers'][$i]['column_info'] ...  不好 [ 文档 ]
显示列注解: 已禁用
已加书签的 SQL 查询: 已禁用
MIME ... 不好 [ 文档 ]
$cfg['Servers'][$i]['history'] ...  不好 [ 文档 ]
SQL 历史: 已禁用

这是为什么啊哪位高手可以教教我啊
小弟在这里先谢谢了

作者: huangmingyou 时间: 2004-08-11 09:00
标题: [求助]关于phpadmin设置的问题,小弟跪求答案!
打电话找空间提供商

作者: 堕落的人生 时间: 2004-08-11 09:09
标题: [求助]关于phpadmin设置的问题,小弟跪求答案!
为什么啊？
是空间商的问题吗？

作者: radar 时间: 2004-12-01 08:18
标题: [求助]关于phpadmin设置的问题,小弟跪求答案!
服务器: localhost 数据库: phpmyadmin
$cfg['Servers'][$i]['pmadb'] ...  确定

$cfg['Servers'][$i]['relation'] ...  确定
一般关系特性: 已启用

$cfg['Servers'][$i]['table_info'] ...  确定
显示特性: 已启用

$cfg['Servers'][$i]['table_coords'] ...  确定
$cfg['Servers'][$i]['pdf_pages'] ...  确定
创建 PDF: 已启用

$cfg['Servers'][$i]['column_info'] ...  确定
显示列注解: 已启用
已加书签的 SQL 查询: 已禁用
MIME ... 确定
$cfg['Servers'][$i]['history'] ...  确定
SQL 历史: 已启用
**********************************************
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://localhost/r18php2/';

/**
* 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'] = '';

/**
* 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]['extension']    = 'mysql';    // The php

MySQL extension to use ('mysql' or 'mysqli')
$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']       = 'root';    // 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']       =

'phpmyadmin';       // 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']    = 'pma_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'] = 'pma_table_info';       // table to describe the display

fields
                                                // - leave blank for no display fields

support
                                                //    DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords']  = 'pma_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']    = 'pma_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'] = 'pma_column_info';       // table to store

column information
                                                // - leave blank for no

column comments/mime types
                                                //    DEFAULT:

'pma_column_info'
$cfg['Servers'][$i]['history']    = 'pma_history';
****************************************************
phpmyadmin 裏的config.inc.php這些改過後就這樣了

作者: odin_free 时间: 2004-12-01 11:19
标题: [求助]关于phpadmin设置的问题,小弟跪求答案!

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)