WAMP环境下phpMyAdmin Designer配置及异常问题咨询

Hey there, let's break down and solve your two main problems with the Designer feature—first the antivirus interference, then the JavaScript error when saving pages. I’ve worked through similar quirks before, so here’s a step-by-step guide:

1. Resolve Kaspersky Total Security Interference #

Kaspersky’s real-time protection and script monitoring are likely blocking phpMyAdmin’s AJAX requests or resource loading for the Designer tool. Try these fixes:

• Add WAMP directory to Kaspersky’s Trusted Zone:
  Open Kaspersky → Go to Settings → Protection → Threats and Exclusions → Exclusions → Add. Select your WAMP root folder (usually C:\wamp64 or your custom path) and check all scanning options (Real-Time Protection, Web Protection, Script Monitoring) to exclude it from checks.
• Whitelist phpMyAdmin in Web Protection:
  In Kaspersky’s Web Protection settings, add http://localhost/phpmyadmin to the allowed sites list. This prevents it from blocking AJAX calls the Designer uses to load table data.
• Exclude phpMyAdmin from Script Monitoring:
  Navigate to Kaspersky’s Script Monitoring settings, add the phpmyadmin subfolder (e.g., C:\wamp64\www\phpmyadmin) to the exclusion list. This stops Kaspersky from interfering with the tool’s JavaScript execution.

2. Fix Fatal JavaScript Error on "Save Page" #

With Kaspersky disabled, this error usually ties to missing phpMyAdmin configuration or database tables. Let’s address it:

• Verify Designer-related Configurations:
  Open your phpMyAdmin config.inc.php file (located in C:\wamp64\www\phpmyadmin). Ensure these lines are present and enabled:

  $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
  $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
  $cfg['Servers'][$i]['designer_coords'] = true;
  $cfg['Servers'][$i]['relation'] = 'pma__relation';
  $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
  

  If any lines are missing, add them. These settings enable the database tables needed to save Designer layouts.
• Ensure phpMyAdmin Database Tables Exist:
  In phpMyAdmin, go to Settings → Features → Create database (under the "pmadb" section). This will generate all required tables like pma__table_coords if they’re missing.
• Clear Caches:
  Force-refresh your browser (press Ctrl+Shift+R) to clear cached JavaScript files. Also, restart WAMP services to ensure new configs take effect.
• Check PHP and MySQL Permissions:
  • In your WAMP php.ini file, confirm allow_url_fopen = On (search for this line, change it if it’s set to Off, then restart WAMP).
  • Make sure your MySQL user (typically root) has full read/write permissions for the phpmyadmin database, especially the pma__table_coords table—this is where Designer saves page layouts.
• Reinstall phpMyAdmin’s JS Files:
  If the JavaScript files are corrupted, download the phpMyAdmin 4.7.9 zip package, extract it, and replace the js folder in your existing phpmyadmin directory with the fresh one.

内容的提问来源于stack exchange，提问作者Milan Stokic