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

From OnnoWiki
Jump to navigation Jump to search
 
(24 intermediate revisions by the same user not shown)
Line 1: Line 1:
Untuk memudahkan pembuatan Distro ada baiknya setup MySQL untuk semua CMS di satukan
+
Untuk memudahkan pembuatan Distro ada baiknya setup [[MySQL]] untuk semua [[CMS]] di satukan
  
  # mysql -u root -p
+
  mysql -u root -p123456
Enter password:
 
  
 
  create database wordpress;
 
  create database wordpress;
Line 19: Line 18:
 
  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;
+
  create database mahara character set UTF8;
  grant INSERT,SELECT on root.* to dms@localhost;
+
grant ALL on mahara.* to mahara@localhost identified by 'mahara';
  grant ALL on dms.* to dms@localhost identified by "dms";
+
grant ALL on mahara.* to mahara identified by 'mahara';
  grant ALL on dms.* to dms identified by "dms";
+
create database cmsbalitbang;
 +
  grant INSERT,SELECT on root.* to cmsbalitbang@localhost;
 +
  grant ALL on cmsbalitbang.* to cmsbalitbang@localhost identified by 'cmsbalitbang';
 +
  grant ALL on cmsbalitbang.* to cmsbalitbang identified by 'cmsbalitbang';
  
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_sd;
 +
GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd'@'localhost' IDENTIFIED BY 'sisfokol_sd';
 +
GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
 +
create database sisfokol_sltp;
 +
GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp';
 +
GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp' IDENTIFIED BY 'sisfokol_sltp';
 +
create database sisfokol_slta;
 +
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta';
 +
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta';
 +
create database sisfokol_smk;
 +
GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk'@'localhost' IDENTIFIED BY 'sisfokol_smk';
 +
GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk' IDENTIFIED BY 'sisfokol_smk';
 +
create database sisfokol_sabily_slta;
 +
GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta'@'localhost' IDENTIFIED BY 'sisfokol_sabily_slta';
 +
GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta' IDENTIFIED BY 'sisfokol_sabily_slta';
 +
create database sisfokol_janissari_v1;
 +
GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari'@'localhost' IDENTIFIED BY 'sisfokol_janissari_v1';
 +
GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari' IDENTIFIED BY 'sisfokol_janissari_v1';
 +
 
  exit
 
  exit
  
Line 43: Line 52:
 
==Setup Tabel==
 
==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
+
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 root -p senayan < /var/www/senayan/install/senayan.sql  
+
  mysql -u senayan -psenayan senayan < /var/www/senayan/install/senayan.sql  
  mysql -u root -p senayan < /var/www/senayan/install/sample_data.sql  
+
  mysql -u senayan -psenayan senayan < /var/www/senayan/install/sample_data.sql  
  mysql dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/structure.sql
+
  mysql dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/data.sql
+
  mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql
  mysql dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/user.sql
+
mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol.sql
 +
mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol.sql
 +
  mysql -u sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol.sql
 +
mysql -u sabily_slta -psisfokol_sabily_slta sisfokol_sabily_slta < /var/www/sisfokol-sabily-sma/db/sep01_1158.sql
 +
  mysql -u janissari -psisfokol_janissari_v1 sisfokol_janissari_v1 < /var/www/janissari/db/agust26_1307.sql
 +
mysql -u cmsbalitbang -pcmsbalitbang cmsbalitbang < /var/www/cmsbalitbang/sql-cms.sql
  
  mysql -u sisfokol_SD_v2 -psisfokol_SD_v2 sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.sql
+
  mysql -u root -p123456 < /var/www/epi/project_db.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
 
  
 
==Pranala Menarik==
 
==Pranala Menarik==
  
 +
* [[Mengatasi Masalah Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock']]
 
* [[Remaster Ubuntu untuk SchoolOnffLine Menggunakan UCK]]
 
* [[Remaster Ubuntu untuk SchoolOnffLine Menggunakan UCK]]
 
* [[SchoolOnffLine: Server Berbasis Sabily 9.04]]
 
* [[SchoolOnffLine: Server Berbasis Sabily 9.04]]
 
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04]]
 
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04]]
 +
* [[SchoolOnffLine: Server Berbasis Ubuntu]]
 +
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04 Alternate]]
 +
* [[SchoolOnffLine: Server Berbasis Ubuntu 9.04 Server]]
 
* [[SchoolOnffLine: Server Wikipedia for School]]
 
* [[SchoolOnffLine: Server Wikipedia for School]]
 
* [[Remastering Ubuntu]]
 
* [[Remastering Ubuntu]]
 +
 +
[[Category: Linux]]
 +
[[Category: Distro Linux]]
 +
[[Category: SchoolOnffLine]]

Latest revision as of 10:25, 26 November 2010

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

mysql -u root -p123456
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 mahara character set UTF8;
grant ALL on mahara.* to mahara@localhost identified by 'mahara';
grant ALL on mahara.* to mahara identified by 'mahara';
create database cmsbalitbang;
grant INSERT,SELECT on root.* to cmsbalitbang@localhost;
grant ALL on cmsbalitbang.* to cmsbalitbang@localhost identified by 'cmsbalitbang';
grant ALL on cmsbalitbang.* to cmsbalitbang identified by 'cmsbalitbang';


create database sisfokol_sd;
GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd'@'localhost' IDENTIFIED BY 'sisfokol_sd';
GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
create database sisfokol_sltp;
GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp';
GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp' IDENTIFIED BY 'sisfokol_sltp';
create database sisfokol_slta;
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta';
GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta';
create database sisfokol_smk;
GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk'@'localhost' IDENTIFIED BY 'sisfokol_smk';
GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk' IDENTIFIED BY 'sisfokol_smk';
create database sisfokol_sabily_slta;
GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta'@'localhost' IDENTIFIED BY 'sisfokol_sabily_slta';
GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta' IDENTIFIED BY 'sisfokol_sabily_slta';
create database sisfokol_janissari_v1;
GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari'@'localhost' IDENTIFIED BY 'sisfokol_janissari_v1';
GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari' 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 -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql
mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol.sql 
mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol.sql
mysql -u sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol.sql
mysql -u sabily_slta -psisfokol_sabily_slta sisfokol_sabily_slta < /var/www/sisfokol-sabily-sma/db/sep01_1158.sql
mysql -u janissari -psisfokol_janissari_v1 sisfokol_janissari_v1 < /var/www/janissari/db/agust26_1307.sql
mysql -u cmsbalitbang -pcmsbalitbang cmsbalitbang < /var/www/cmsbalitbang/sql-cms.sql
mysql -u root -p123456 < /var/www/epi/project_db.sql

Pranala Menarik