Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Running these commands in MySQL will create three databases where the user "sharetribe" has access. DON'T FORGET TO CHANGE ALL THE put_a_password_here PARTS TO A SECURE PASSWORD!
CREATE DATABASE sharetribe_test CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE sharetribe_development CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE sharetribe_production CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT all privileges ON sharetribe_development.* TO 'sharetribe'@'localhost' IDENTIFIED BY 'put_a_password_here';
GRANT all privileges ON sharetribe_production.* TO 'sharetribe'@'localhost' IDENTIFIED BY 'put_a_password_here';
GRANT all privileges ON sharetribe_test.* TO 'sharetribe'@'localhost' IDENTIFIED BY 'put_a_password_here';
@iamnathanwindsor

This comment has been minimized.

Copy link

commented Nov 3, 2015

I'm having trouble with lines 5-7, my Mysql terminal isn't picking those lines up and is prompting an error message.

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘password';

Any ideas what I'm doing wrong?

@thomassnielsen

This comment has been minimized.

Copy link

commented Nov 3, 2015

@iamnathanwindsor you seem to get pretty quotes around your password. Make sure it's 'your_password', not ´password´ or similar.

@iamnathanwindsor

This comment has been minimized.

Copy link

commented Nov 18, 2015

Hi Thomas, thanks for responding, I appreciate your help!

Here's an additional error I got. I don't see creating this file anywhere in your directions, so I'm a bit confused.

Mysql2::Error: Table 'sharetribe_development.communities' doesn't exist: SHOW FULL FIELDS FROM communities

screen shot 2015-11-17 at 10 16 51 pm

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.