Changes between Version 71 and Version 72 of ServerIntro


Ignore:
Timestamp:
Feb 20, 2013, 7:07:53 AM (9 years ago)
Author:
Christian Beer
Comment:

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

Legend:

Unmodified
Added
Removed
Modified
  • ServerIntro

    v71 v72  
    153153grant all on *.* to nobody@localhost identified by 'password';
    154154grant all on *.* to nobody identified by 'password';
     155}}}
     156
     157{{{
     158#!comment
     159This 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.
     160
     161mysql -u root
     162CREATE DATABASE `db_name`;
     163CREATE USER 'db_user'@'localhost' IDENTIFIED BY  'db_password';
     164GRANT USAGE ON *.* TO 'db_user'@'localhost'
     165GRANT ALL PRIVILEGES ON  `db_name`.* TO 'db_user'@'localhost';
     166
     167mysql -u root
     168REVOKE ALL PRIVILEGES ON  *.* FROM  'db_name'@'localhost';
     169REVOKE ALL PRIVILEGES ON  *.* FROM  'nobody'@'localhost';
    155170}}}
    156171 * Set your `PATH` environment variable to include MySQL programs