Skip to content

Instantly share code, notes, and snippets.

@claylo

claylo/jira.sql

Created April 25, 2011 21:54
Show Gist options
  • Save claylo/941331 to your computer and use it in GitHub Desktop.
Save claylo/941331 to your computer and use it in GitHub Desktop.
Download ZIP
Atlassian JIRA database & user creation for MySQL.
Raw
jira.sql
#
# You will want to pick a real password here!
#
CREATE USER 'jirauser'@'localhost' IDENTIFIED BY 'some_pass';
CREATE DATABASE jira CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON jira.* to 'jirauser'@'localhost';
FLUSH PRIVILEGES;
# In case you forgot to change the password above...
# SET PASSWORD for 'jirauser'@'localhost' = PASSWORD('someother_pass');
@jefft
Copy link

jefft commented Mar 16, 2022

Per the Atlassian docs, that should be:

CREATE DATABASE jira CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

utf8mb4 is real UTF-8, unlikeutf8 (see discussion), and has been the correct choice since MySQL 5.5.3 released in 2010.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment