summaryrefslogtreecommitdiff
path: root/sql/schema/create-database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/schema/create-database.sql')
-rw-r--r--sql/schema/create-database.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/schema/create-database.sql b/sql/schema/create-database.sql
new file mode 100644
index 0000000..088893f
--- /dev/null
+++ b/sql/schema/create-database.sql
@@ -0,0 +1,5 @@
+CREATE DATABASE IF NOT EXISTS `faredge` /*!40100 DEFAULT CHARACTER SET utf8 */;
+
+GRANT ALL PRIVILEGES ON faredge.* TO faredge@'%' IDENTIFIED BY 'password_changeme';
+GRANT ALL PRIVILEGES ON faredge.* TO faredge@localhost IDENTIFIED BY 'password_changeme';
+FLUSH PRIVILEGES;