Author Topic: Development Setup Guide  (Read 1079 times)

0 Members and 1 Guest are viewing this topic.

Offline Thing342

  • Computer Guy
  • TM Collaborator
  • Newbie
  • *****
  • Posts: 13
  • Gender: Male
  • Last Login:June 08, 2017, 10:58:40 pm
  • V.T.C.S.
    • Personal Page
Development Setup Guide
« 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.

Post any questions you may have here.

Offline rschen7754

  • Newbie
  • *
  • Posts: 43
  • Gender: Male
  • Last Login:Yesterday at 01:24:46 am
    • Rschen7754
Re: Development Setup Guide
« Reply #1 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.
« Last Edit: August 21, 2017, 12:28:55 am by rschen7754 »