Difference between revisions of "SchoolOnffLine: Setup MySQL untuk Semua CMS"

From OnnoWiki
Jump to navigation Jump to search
(New page: 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 wo...)
 
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';
 +
exit
  
  

Revision as of 09:59, 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';
exit




Pranala Menarik