- 论坛徽章:
- 0
|
网站是网上空间商提供的现在出现了这样的情况
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 历史: 已禁用
这是为什么啊哪位高手可以教教我啊
小弟在这里先谢谢了  |
|
免费注册
发表于 2004-08-10 20:44
