Difference between revisions of "SchoolOnffLine: Setup MySQL untuk Semua CMS"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| Line 19: | Line 19: | ||
GRANT ALL PRIVILEGES ON senayan.* TO 'senayan'@'localhost' IDENTIFIED BY 'senayan'; | GRANT ALL PRIVILEGES ON senayan.* TO 'senayan'@'localhost' IDENTIFIED BY 'senayan'; | ||
GRANT ALL PRIVILEGES ON senayan.* TO 'senayan' IDENTIFIED BY 'senayan'; | GRANT ALL PRIVILEGES ON senayan.* TO 'senayan' IDENTIFIED BY 'senayan'; | ||
| + | create database dms; | ||
| + | grant INSERT,SELECT on root.* to dms@localhost; | ||
| + | grant ALL on dms.* to dms@localhost identified by "dms"; | ||
| + | grant ALL on dms.* to dms identified by "dms"; | ||
exit | exit | ||
Revision as of 11:25, 4 August 2009
Untuk memudahkan pembuatan Distro ada baiknya setup MySQL untuk semua CMS di satukan
# mysql -u root -p Enter password:
create database wordpress; grant INSERT,SELECT on root.* to wordpress@localhost; grant ALL on wordpress.* to wordpress@localhost identified by 'wordpress'; grant ALL on wordpress.* to wordpress identified by 'wordpress'; create database mediawiki; grant INSERT,SELECT on root.* to mediawiki@localhost; grant ALL on mediawiki.* to mediawiki@localhost identified by 'mediawiki'; grant ALL on mediawiki.* to mediawiki identified by 'mediawiki'; create database moodle; grant INSERT,SELECT on root.* to moodle@localhost; grant ALL on moodle.* to moodle@localhost identified by "moodle"; grant ALL on moodle.* to moodle identified by "moodle"; create database senayan; GRANT ALL PRIVILEGES ON senayan.* TO 'senayan'@'localhost' IDENTIFIED BY 'senayan'; GRANT ALL PRIVILEGES ON senayan.* TO 'senayan' IDENTIFIED BY 'senayan'; create database dms; grant INSERT,SELECT on root.* to dms@localhost; grant ALL on dms.* to dms@localhost identified by "dms"; grant ALL on dms.* to dms identified by "dms"; exit