Install Alegro Cart 1.2.9 with XAMPP 5.6.28 on Windows 7 localhost - PHP eCommerce

Trabla: Install Alegro Cart 1.2.9 with XAMPP 5.6.28 on Windows 7 localhost - PHP eCommerce

Alegro Cart - free open source E-Commerce shopping cart solution, MVC Design, modular template system, PHP 5, MySQL 5 database, multiple languages and autoupdate.

Solving:

Watch on YouTube

SQL script to create user and database for Alegro Cart 1.2.9, used in tutorial:


CREATE DATABASE `alegro` 
DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

CREATE USER 'alegroowner'@'localhost'; 
CREATE USER 'alegroowner'@'127.0.0.1';
CREATE USER 'alegroowner'@'::1';

SET PASSWORD 
FOR 'alegroowner'@'localhost' = PASSWORD('alegro123');
SET PASSWORD 
FOR 'alegroowner'@'127.0.0.1' = PASSWORD('alegro123');
SET PASSWORD 
FOR 'alegroowner'@'::1' = PASSWORD('alegro123');


GRANT ALL PRIVILEGES ON 
`alegro`.* TO 'alegroowner'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`alegro`.* TO 'alegroowner'@'127.0.0.1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`alegro`.* TO 'alegroowner'@'::1' WITH GRANT OPTION;