注册
登录
| 关键词： Servers phpmyadmin PMA Database cfg table create tables info relation |
作者：startkill 来自：http://www.chinaunix.net/ "使用链接表的额外特性尚未激活.."修正办法! 在使用了新的phpmyadmin (2.6.0-beta*或者更高版本) 来管理mysql后,你每打开一个库的时候,会看到这么一句: 错误 使用链接表的额外特性尚未激活。要查出原因，请单击此处。 单击了所谓的此处后,会跳到一个页面显示: PMA Database ... 不好[ 文档 ] 一般关系特性 已禁用 （这是因为phpmyadin加了新功能。解决办法是 一，新建一个名字为phpmyadin的数据库 二。在phpmyadin中建数据表，可以直接从phpmyadin的scripts文件夹中导入sql文件，文件名字为create_tables.sql。 三，配置 config.inc.php 事实上也就是把你建立的表名称填到对应的位置。 ） 其实在cofnig.inc.php后面就有缺省的键值，填上去就可以了，当然你也可以通过create_table.sql文件来写。只不过后面这个要麻烦些（）Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you need special tables with a predefined structure, which we explain below. See the Quick Install section in this document for a quick way of creating those tables. Also, if you are using a Windows server, read FAQ 1.23. If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. If you are setting up a multi-user phpMyAdmin installation, you will need to create a new database and setup special privileges, so, as superuser: create a new database for phpMyAdmin: CREATE DATABASE phpmyadmin; Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser): GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost'; do not give any other user rights on this database. enter the database name in $cfg['Servers'][$i]['pmadb'] 1.先建立一个名为phpmyadmin的数据库 2.然后把目录下scripts/create_tables.sql导入到这个库 mysqldir/bin/mysql -u root -p /phpadmin_dir/scripts/create_tables.sql 3.打开config.inc.php配置文件. $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]['pmadb'] = 'phpmyadmin'; // 'phpmyadmin' - see scripts/create_tables.sql $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // 'pma_bookmark' $cfg['Servers'][$i]['relation'] = 'pma_relation'; // 'pma_relation' $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // 'pma_table_info' $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // 'pma_table_coords' $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // 'pma_pdf_pages' $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // 'pma_column_info' $cfg['Servers'][$i]['history'] = 'pma_history'; // 'pma_history' 这样保存后刷新页面就好了`` |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
