~darrencassar/crib/trunk

« back to all changes in this revision

Viewing changes to README

  • Committer: root
  • Date: 2010-10-24 00:24:00 UTC
  • Revision ID: root@ubt-20101024002400-6bfsfef7u5kgnv5k
permissions

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
 
1
2
install INSTALL/crib.sql on the destination
2
3
install INSTALL/crib_reporting.sql on the destination
3
4
install INSTALL/info_user_privileges.sql on the destination
26
27
    table_schema varchar(64) NOT NULL,
27
28
    privileges text
28
29
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
 
30
 
 
31
 
 
32
CRIB:
 
33
grant create, insert, alter, update, delete, select, drop, execute, create temporary tables, creat routine, alter routine, lock tables on crib.* to "mother"@"%" identified by "teacher";
 
34
 
 
35
CLIENT
 
36
grant create, alter, insert, delete, select, drop, lock tables on crib_client.* to "child"@"%" identified by "abc";
 
37
grant select on mysql.user TO 'child'@'%';
 
38
grant select on *.* to 'child'@'%';