Skip to content

Instantly share code, notes, and snippets.

@DasBlub
Created January 23, 2011 17:12
Show Gist options
  • Save DasBlub/792218 to your computer and use it in GitHub Desktop.
Save DasBlub/792218 to your computer and use it in GitHub Desktop.
SD2: Improve security for the MySQL DB
Index: sql/scriptdev2_create_database.sql
===================================================================
--- sql/scriptdev2_create_database.sql (revision 1954)
+++ sql/scriptdev2_create_database.sql (working copy)
@@ -1,4 +1,3 @@
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-GRANT ALL PRIVILEGES ON `scriptdev2` . * TO 'mangos'@'localhost' WITH GRANT OPTION;
-
+GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, LOCK TABLES ON `scriptdev2`.* TO 'mangos'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment