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!

Sharetribe DB installation

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';

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?

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

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