Changes between Version 71 and Version 72 of ServerIntro

Timestamp:

Feb 20, 2013, 7:07:53 AM (11 years ago)

Author:

Christian Beer

Comment:

a more secure mysql permission set (not yet implemented!)

ServerIntro

@@ -153 +153 @@
 grant all on *.* to nobody@localhost identified by 'password';
 grant all on *.* to nobody identified by 'password';
+}}}
+
+{{{
+#!comment
+This is a more secure approach but will not work for new projects because make_project tries to create and drop the database on its own. Existing projects should change the permissions accordingly.
+
+mysql -u root
+CREATE DATABASE `db_name`;
+CREATE USER 'db_user'@'localhost' IDENTIFIED BY  'db_password';
+GRANT USAGE ON *.* TO 'db_user'@'localhost'
+GRANT ALL PRIVILEGES ON  `db_name`.* TO 'db_user'@'localhost';
+
+mysql -u root
+REVOKE ALL PRIVILEGES ON  *.* FROM  'db_name'@'localhost';
+REVOKE ALL PRIVILEGES ON  *.* FROM  'nobody'@'localhost';
 }}}
  * Set your `PATH` environment variable to include MySQL programs