Install SugarCRM CE 6.5.24 on Windows 7 localhost ( XAMPP 5.6.24 ) - PHP CRM

Trabla: Install SugarCRM Community Edition ( CE ) 6.5.24 on Windows 7 x64 localhost ( XAMPP 5.6.24 ) - PHP CRM

SugarCRM - a customer relationship management (CRM) system that is available in both open-source and commercial open-source applications.

Solving:

Watch on YouTube

/* SQL script to create database and user for SugarCRM, used in tutorial: */

CREATE DATABASE `sugarcrm` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'sugarcrm-owner'@'localhost';

CREATE USER 'sugarcrm-owner'@'127.0.0.1';

CREATE USER 'sugarcrm-owner'@'::1';

SET PASSWORD FOR 'sugarcrm-owner'@'localhost' = PASSWORD('sugarcrm123$%');

SET PASSWORD FOR 'sugarcrm-owner'@'127.0.0.1' = PASSWORD('sugarcrm123$%');

SET PASSWORD FOR 'sugarcrm-owner'@'::1' = PASSWORD('sugarcrm123$%');

GRANT ALL PRIVILEGES ON `sugarcrm`.* TO 'sugarcrm-owner'@'localhost' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `sugarcrm`.* TO 'sugarcrm-owner'@'127.0.0.1' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `sugarcrm`.* TO 'sugarcrm-owner'@'::1' WITH GRANT OPTION;