Windows

Uniform Server

Uniform Server:

• A free lightweight portable WAMP server solution.

• Includes the latest versions of Apache, MySQL or MariaDB, PHP (with version switching), phpMyAdmin or Adminer.

• PHP 7: Download

• PHP 8: Download

XAMPP

XAMPP:

• XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and start the installer. It's that easy.

• PHP 7: Download

• PHP 8: Download

XAMPP MySQL Fix Option 1:

• MySQL backup folder which is included with XAMPP.

• Rename the folder mysql/data to mysql/data_old (you can use any name)

• Create a new folder mysql/data

• Copy the content that resides in mysql/backup to the new mysql/data folder

• Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)

• Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder

• Start MySQL from XAMPP control panel

XAMPP MySQL Fix Option 2:

• Stop MySQL.

• Go to the C:/xampp/mysql directory and copy the data folder and keep it somewhere else (probably in another drive) as a backup.

• Go to your original data folder (C:/xampp/mysql) and sort the files by 'Type.'

• Select the files that have the type INFO File and delete them.

• Start MySQL. It should work now.