SchoolOnffLine: Setup MySQL untuk Semua CMS

From OnnoWiki
Revision as of 06:47, 7 September 2009 by Onnowpurbo (talk | contribs)
Jump to navigation Jump to search

Untuk memudahkan pembuatan Distro ada baiknya setup MySQL untuk semua CMS di satukan

# mysql -u root -p
Enter password: <123456>
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@localhost identified by 'dms';
grant ALL on dms.* to dms identified by 'dms';
create database sisfokol_SD_v2;
GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2'@'localhost' IDENTIFIED BY 'sisfokol_SD_v2';
GRANT ALL PRIVILEGES ON sisfokol_SD_v2.* TO 'sisfokol_SD_v2' IDENTIFIED BY 'sisfokol_SD_v2';
create database sisfokol_sltp_v2;
GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2'@'localhost' IDENTIFIED BY 'sisfokol_sltp_v2';
GRANT ALL PRIVILEGES ON sisfokol_sltp_v2.* TO 'sisfokol_sltp_v2' IDENTIFIED BY 'sisfokol_sltp_v2';
create database sisfokol_slta_v2;
GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2'@'localhost' IDENTIFIED BY 'sisfokol_slta_v2';
GRANT ALL PRIVILEGES ON sisfokol_slta_v2.* TO 'sisfokol_slta_v2' IDENTIFIED BY 'sisfokol_slta_v2';
create database sisfokol_smk_v2;
GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2'@'localhost' IDENTIFIED BY 'sisfokol_smk_v2';
GRANT ALL PRIVILEGES ON sisfokol_smk_v2.* TO 'sisfokol_smk_v2' IDENTIFIED BY 'sisfokol_smk_v2';
create database sisfokol_sabily_slta;
GRANT ALL PRIVILEGES ON sabily_slta.* TO 'sisfokol_sabily_slta'@'localhost' IDENTIFIED BY 'sisfokol_sabily_slta';
GRANT ALL PRIVILEGES ON sabily_slta.* TO 'sisfokol_sabily_slta' IDENTIFIED BY 'sisfokol_sabily_slta';
create database sisfokol_janissari_v1;
GRANT ALL PRIVILEGES ON janissari.* TO 'sisfokol_janissari_v1'@'localhost' IDENTIFIED BY 'sisfokol_janissari_v1';
GRANT ALL PRIVILEGES ON janissari.* TO 'sisfokol_janissari_v1' IDENTIFIED BY 'sisfokol_janissari_v1';

exit


Setup Tabel

Setup tabel dilakukan melalui shell dan hanya dapat dilakukan jika database sudah dibuat dan [[source code}] sudah di copy ke folder di bawah /var/www

mysql -u senayan -psenayan senayan < /var/www/senayan/install/senayan.sql 
mysql -u senayan -psenayan senayan < /var/www/senayan/install/sample_data.sql 

mysql -u sisfokol_SD_v2 -psisfokol_SD_v2 sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.sql
mysql -u sisfokol_sltp_v2 -psisfokol_sltp_v2 sisfokol_sltp_v2 < /var/www/sisfokol-sltp/db/agust18_0929.sql 
mysql -u sisfokol_slta_v2 -psisfokol_slta_v2 sisfokol_slta_v2 < /var/www/sisfokol-slta/db/agust15_1505.sql 
mysql -u sisfokol_smk_v2 -psisfokol_smk_v2 sisfokol_smk_v2 < /var/www/sisfokol-smk/db/sept04_1155.sql
mysql -u dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/structure.sql
mysql -u dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/data.sql
mysql -u root -p dms < /var/www/knowledgeTree/sql/mysql/install/user.sql

Pranala Menarik