Travel Mapping

Web Design Discussion => General Web Design Discussion => Topic started by: Thing342 on January 13, 2017, 05:51:16 pm

Title: Development Setup Guide
Post by: Thing342 on January 13, 2017, 05:51:16 pm
Hey guys, I finally got around to writing this. I only have experience setting this up on Linux environments, so if you have set this up on Windows, please feel free to edit the page.

https://github.com/TravelMapping/Web/wiki/Development-Setup-Guide (https://github.com/TravelMapping/Web/wiki/Development-Setup-Guide)

Post any questions you may have here.
Title: Re: Development Setup Guide
Post by: rschen7754 on August 20, 2017, 06:12:55 pm
This statement fails with an error 1221:

GRANT SELECT, SHOW VIEW, PROCESS, REPLICATION CLIENT ON TravelMapping.* to '<New Username>'@'localhost' IDENTIFIED by '<New Password>';

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGE

I had to split each GRANT command into different parts, and change TravelMapping.* to *.* on the last two.

Also, it seems that php5-mysqlnd is no longer available on 16.04 - I had to use php7.0-mysqlnd.

In MySQL since I'm on the latest version, I had to use the following commands to emulate older behavior:

alter schema TravelMapping default character set utf8
SET @@global.sql_mode= '';

In the end I did get it to work though.