如何启用phpMyAdmin的Designer视图? [英] How do I enable phpMyAdmin's Designer view?
问题描述
我正在本地运行phpMyAdmin,并且正在尝试启用设计器工具.
I am running phpMyAdmin locally and I am trying to enable the Designer tool.
如何为phpMyAdmin启用设计器视图?
How do you enable designer view for phpMyAdmin?
我已经阅读了很多有关如何为phpMyAdmin启用Designer视图的教程,并且它们都有不同的方向,这些方向似乎从未使它真正起作用.
I have read quite a few tutorials on how to enable the Designer view for phpMyAdmin and they all have different directions that never seem to actually get it working.
我正在使用4.0.7版本
I am using version 4.0.7
推荐答案
以下步骤将假定phpMyAdmin位于文件夹phpMyAdmin
中,从而在phpMyAdmin 4+中启用设计器:
The following steps will enable the Designer in phpMyAdmin 4+ assuming that phpMyAdmin is inside the folder phpMyAdmin
:
- 打开
phpMyAdmin/config.inc.php
和phpMyAdmin/config.sample.inc.php
. - 在
config.sample.inc.php
中找到phpMyAdmin配置存储设置(4.0.7中的第38-66行). - 复制所有控制用户和存储db/table配置并将其粘贴到
config.inc.php
中.完成后,您的config.inc.php应该包含以下内容:
- Open
phpMyAdmin/config.inc.php
andphpMyAdmin/config.sample.inc.php
. - Locate the phpMyAdmin configuration storage settings in
config.sample.inc.php
(lines 38-66 in 4.0.7). - Copy all of the control user and storage db/table config and paste it into
config.inc.php
. When you get done, your config.inc.php should include something like this:
4.0.7示例:
/* change this info to whatever user has read-only access to the "mysql/user" and "mysql/db" tables */
$cfg['Servers'][$i]['controluser'] = 'root'; //this is the default user for MAMP's mysql
$cfg['Servers'][$i]['controlpass'] = 'root'; //this is the default password for MAMP's mysql
/* this information needs to line up with the database we're about to create so don't edit it unless you plan on editing the SQL we're about to run */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
注意:我们只是告诉phpMyAdmin哪些数据库和表名用于存储特定的配置详细信息.现在添加数据库.
- phpMyAdmin随SQL一起安装,我们需要生成设计器所依赖的数据库.我们只需要找到脚本.在4.0.7中,文件位置为
phpMyAdmin/examples/create_tables.sql
.或者,您可以从 phpMyAdmin的github 复制/下载. - 找到文件后,要么导入文件,要么将其复制/粘贴到SQL窗口中并在phpMyAdmin中执行.
- 现在,应正确配置所有内容.我们需要清除cookie并重新启动浏览器.
- 在备份中打开phpMyAdmin时,导航到特定表,然后在标签中看到设计器"标签.
- phpMyAdmin installs with the SQL we need to generate the database that the Designer relies on. We just need to locate the script. In 4.0.7 the file location is
phpMyAdmin/examples/create_tables.sql
. Alternatively, you can copy/download this from phpMyAdmin's github. - Once you locate the file, either import the file or copy/paste it into a SQL window and execute in phpMyAdmin.
- Now, everything should be configured properly. We need to clear cookies and restart the browser.
- When you open phpMyAdmin back up, navigate to a specific table and in the tabs you should see Designer tab.
免责声明:这些说明专门基于phpMyAdmin 4+中的新文件夹结构.您可以使用phpMyAdmin的github config.sample.php
和随附的create-table.sql
来应用相同的说明.通过选择正确的分支来选择您的phpMyAdmin版本.
Disclaimer: These directions are specifically based on the new folder structure in phpMyAdmin 4+. You can apply the same directions by using phpMyAdmin's github config.sample.php
and the accompanying create-table.sql
. Choose your phpMyAdmin version by selecting the correct branch.
这篇关于如何启用phpMyAdmin的Designer视图?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!