如何通过Xampp本地部署Acumatica？安装时遇“Unknown system variable 'information_schema_stats_expiry'”错误的解决方法

Hey there, let's work through your Acumatica deployment issues with XAMPP—first fixing that error, then walking through the full setup step by step.

1. Resolving the "Unknown system variable 'information_schema_stats_expiry'" Error #

This error pops up because the information_schema_stats_expiry system variable was only introduced in MySQL 8.0, and the MySQL version bundled with your current XAMPP install is older than that. Acumatica requires MySQL 8.0 or higher, so version mismatch is the root cause.

Here's how to fix it:

• First, confirm your MySQL version: Open the XAMPP Control Panel, start MySQL, click the "Shell" button, then run mysql -V to see your current version number.
• Upgrade XAMPP to a version with MySQL 8.0+:
  1. Backup your existing MySQL data first—your databases are stored in xampp\mysql\data; copy this folder to a safe location to avoid data loss.
  2. Download the latest XAMPP version that includes MySQL 8.0 (from the Apache Friends official site, make sure to check the MySQL version listed for the installer).
  3. Uninstall your old XAMPP (or do an overwrite install, but backup first!).
  4. After installing the new XAMPP, replace the xampp\mysql\data folder with your backup, then start MySQL to confirm it runs without issues.

If you don't want to reinstall the entire XAMPP stack, you can upgrade just the MySQL component, but that's more complex—full XAMPP upgrade is the simpler, safer route.

2. Full Local Acumatica Deployment with XAMPP #

Before starting, make sure:

• Your XAMPP has MySQL 8.0+ and Apache running smoothly.
• Your Windows system meets Acumatica's requirements (like .NET Framework 4.8+, at least 8GB RAM, and enough disk space).

Follow these steps:

• Get the Acumatica installer: Grab the correct version of the Acumatica ERP installer from the official source (e.g., 2023 R2, 2024 R1).
• Set up your MySQL database:
  1. Start MySQL in XAMPP, then open phpMyAdmin by clicking the "Admin" button next to MySQL in the control panel.
  2. Create a new database (e.g., AcumaticaDB), set the character set to utf8mb4 and collation to utf8mb4_general_ci—this matches Acumatica's requirements.
  3. Create a dedicated MySQL user (e.g., acumatica_user), set a strong password, and grant this user full permissions to the AcumaticaDB database.
• Run the Acumatica installer:
  1. Right-click the Acumatica installer and select "Run as administrator"—this avoids permission-related hiccups during installation.
  2. Follow the wizard: Choose "Full Installation" for a test environment (or "Custom" if you need specific components).
  3. When you reach the database configuration step:
     • Select "MySQL" as the database type.
     • Enter localhost (or 127.0.0.1) as the server name, 3306 as the port (unless you changed MySQL's default port).
     • Input the database name (AcumaticaDB), username (acumatica_user), and password you set earlier.
  4. Continue through the wizard: Pick a port for your Acumatica site (default is 80; if Apache is using 80, use something like 8080), then set up your Acumatica admin account and password.
• Verify the deployment:
  1. Once installation finishes, the wizard should automatically open the Acumatica site. If not, navigate to http://localhost:[your-chosen-port] in your browser.
  2. Log in with your admin credentials, check that the dashboard loads, and test accessing a few modules to confirm everything works.
• Optional post-setup tweaks:
  • Configure an Apache virtual host in XAMPP to access Acumatica via a custom local domain (like acumatica.local).
  • Set up regular backups of both the MySQL database and Acumatica's installation directory (default is C:\Program Files\Acumatica ERP or your custom path).

内容的提问来源于stack exchange，提问作者heather murphy