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

From OnnoWiki
Jump to navigation Jump to search
Line 24: Line 24:
 
  grant ALL on dms.* to dms identified by "dms";
 
  grant ALL on dms.* to dms identified by "dms";
 
  exit
 
  exit
 +
 +
 +
 +
==Setup Tabel==
 +
 +
mysql -u root -p senayan < /var/www/senayan/install/senayan.sql
 +
mysql -u root -p senayan < /var/www/senayan/install/sample_data.sql
 +
mysql -p dms < /var/www/knowledgeTree/sql/mysql/install/structure.sql
 +
mysql -p dms < /var/www/knowledgeTree/sql/mysql/install/data.sql
 +
mysql -p dms < /var/www/knowledgeTree/sql/mysql/install/user.sql
  
  

Revision as of 11:38, 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


Setup Tabel

mysql -u root -p senayan < /var/www/senayan/install/senayan.sql 
mysql -u root -p senayan < /var/www/senayan/install/sample_data.sql 
mysql -p dms < /var/www/knowledgeTree/sql/mysql/install/structure.sql
mysql -p dms < /var/www/knowledgeTree/sql/mysql/install/data.sql
mysql -p dms < /var/www/knowledgeTree/sql/mysql/install/user.sql




Pranala Menarik

Retrieved from "https://onnocenter.or.id/wiki/index.php?title=SchoolOnffLine:_Setup_MySQL_untuk_Semua_CMS&oldid=7270"