SchoolOnffLine: Setup MySQL untuk Semua CMS - Revision history

Onnowpurbo: /* Pranala Menarik */

2010-11-26T03:25:03Z

Pranala Menarik

← Older revision		Revision as of 03:25, 26 November 2010
Line 69:		Line 69:
	==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]]

Onnowpurbo at 11:11, 17 November 2010

2010-11-17T11:11:29Z

← Older revision		Revision as of 11:11, 17 November 2010
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 -p123456		mysql -u root -p123456

	create database wordpress;		create database wordpress;
Line 7:		Line 7:
	grant ALL on wordpress.* to wordpress@localhost identified by 'wordpress';		grant ALL on wordpress.* to wordpress@localhost identified by 'wordpress';
	grant ALL on wordpress.* to wordpress identified by 'wordpress';		grant ALL on wordpress.* to wordpress identified by 'wordpress';
	~~create database wordpressmu;~~
	~~grant INSERT,SELECT on root.* to wordpressmu@localhost;~~
	~~grant ALL on wordpressmu.* to wordpressmu@localhost identified by 'wordpressmu';~~
	~~grant ALL on wordpressmu.* to wordpressmu identified by 'wordpressmu';~~
	create database mediawiki;		create database mediawiki;
	grant INSERT,SELECT on root.* to mediawiki@localhost;		grant INSERT,SELECT on root.* to mediawiki@localhost;
Line 29:		Line 25:
	grant ALL on cmsbalitbang.* to cmsbalitbang@localhost identified by 'cmsbalitbang';		grant ALL on cmsbalitbang.* to cmsbalitbang@localhost identified by 'cmsbalitbang';
	grant ALL on cmsbalitbang.* to cmsbalitbang identified by 'cmsbalitbang';		grant ALL on cmsbalitbang.* to cmsbalitbang identified by 'cmsbalitbang';
	~~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;		create database sisfokol_sd;
Line 73:		Line 65:
	mysql -u cmsbalitbang -pcmsbalitbang cmsbalitbang < /var/www/cmsbalitbang/sql-cms.sql		mysql -u cmsbalitbang -pcmsbalitbang cmsbalitbang < /var/www/cmsbalitbang/sql-cms.sql

	~~mysql -u dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/structure.sql~~		mysql -u root -p123456 < /var/www/epi/project_db.sql
	~~mysql -u dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/data.sql~~
	mysql -u root -p123456 ~~dms~~ < /var/www/~~knowledgeTree/sql/mysql/install~~/~~user~~.sql

	==Pranala Menarik==		==Pranala Menarik==

Onnowpurbo: /* Pranala Menarik */

2010-05-11T01:34:32Z

Pranala Menarik

← Older revision		Revision as of 01:34, 11 May 2010
Line 87:		Line 87:
	* [[SchoolOnffLine: Server Wikipedia for School]]		* [[SchoolOnffLine: Server Wikipedia for School]]
	* [[Remastering Ubuntu]]		* [[Remastering Ubuntu]]

			[[Category: Linux]]
			[[Category: Distro Linux]]
			[[Category: SchoolOnffLine]]

Onnowpurbo: /* Setup Tabel */

2010-01-25T03:47:41Z

Setup Tabel

← Older revision		Revision as of 03:47, 25 January 2010
Line 66:		Line 66:

	mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.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/~~jan11_1026~~.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_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 sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol.sql

Onnowpurbo: /* Setup Tabel */

2010-01-25T02:58:39Z

Setup Tabel

← Older revision		Revision as of 02:58, 25 January 2010
Line 60:		Line 60:
	==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 senayan -psenayan senayan < /var/www/senayan/install/senayan.sql		mysql -u senayan -psenayan senayan < /var/www/senayan/install/senayan.sql
Line 66:		Line 66:

	mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.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_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/jan11_1026.sql
	mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/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 sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol.sql

Onnowpurbo at 02:50, 25 January 2010

2010-01-25T02:50:56Z

← Older revision		Revision as of 02:50, 25 January 2010
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: <123456>~~

	create database wordpress;		create database wordpress;
Line 36:		Line 35:
	grant ALL on dms.* to dms identified by 'dms';		grant ALL on dms.* to dms identified by 'dms';

	create database ~~sisfokol_SD_v2~~;		create database sisfokol_sd;
	GRANT ALL PRIVILEGES ON ~~sisfokol_SD_v2~~.* TO '~~sisfokol_SD_v2~~'@'localhost' IDENTIFIED BY '~~sisfokol_SD_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd'@'localhost' IDENTIFIED BY 'sisfokol_sd';
	GRANT ALL PRIVILEGES ON ~~sisfokol_SD_v2~~.* TO '~~sisfokol_SD_v2~~' IDENTIFIED BY '~~sisfokol_SD_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd';
	create database ~~sisfokol_sltp_v2~~;		create database sisfokol_sltp;
	GRANT ALL PRIVILEGES ON ~~sisfokol_sltp_v2~~.* TO '~~sisfokol_sltp_v2~~'@'localhost' IDENTIFIED BY '~~sisfokol_sltp_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp';
	GRANT ALL PRIVILEGES ON ~~sisfokol_sltp_v2~~.* TO '~~sisfokol_sltp_v2~~' IDENTIFIED BY '~~sisfokol_sltp_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp' IDENTIFIED BY 'sisfokol_sltp';
	create database ~~sisfokol_slta_v2~~;		create database sisfokol_slta;
	GRANT ALL PRIVILEGES ON ~~sisfokol_slta_v2~~.* TO '~~sisfokol_slta_v2~~'@'localhost' IDENTIFIED BY '~~sisfokol_slta_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta';
	GRANT ALL PRIVILEGES ON ~~sisfokol_slta_v2~~.* TO '~~sisfokol_slta_v2~~' IDENTIFIED BY '~~sisfokol_slta_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta';
	create database ~~sisfokol_smk_v2~~;		create database sisfokol_smk;
	GRANT ALL PRIVILEGES ON ~~sisfokol_smk_v2~~.* TO '~~sisfokol_smk_v2~~'@'localhost' IDENTIFIED BY '~~sisfokol_smk_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk'@'localhost' IDENTIFIED BY 'sisfokol_smk';
	GRANT ALL PRIVILEGES ON ~~sisfokol_smk_v2~~.* TO '~~sisfokol_smk_v2~~' IDENTIFIED BY '~~sisfokol_smk_v2~~';		GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk' IDENTIFIED BY 'sisfokol_smk';
	create database sisfokol_sabily_slta;		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'@'localhost' IDENTIFIED BY 'sisfokol_sabily_slta';
Line 66:		Line 65:
	mysql -u senayan -psenayan senayan < /var/www/senayan/install/sample_data.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_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql
	mysql -u ~~sisfokol_sltp_v2~~ -~~psisfokol_sltp_v2 sisfokol_sltp_v2~~ < /var/www/sisfokol-smp/db/~~agust18_0929~~.sql		mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol.sql
	mysql -u ~~sisfokol_slta_v2~~ -~~psisfokol_slta_v2 sisfokol_slta_v2~~ < /var/www/sisfokol-sma/db/~~agust15_1505~~.sql		mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol.sql
	mysql -u ~~sisfokol_smk_v2~~ -~~psisfokol_smk_v2 sisfokol_smk_v2~~ < /var/www/sisfokol-smk/db/~~sept04_1155~~.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 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 janissari -psisfokol_janissari_v1 sisfokol_janissari_v1 < /var/www/janissari/db/agust26_1307.sql

Onnowpurbo: /* Setup Tabel */

2010-01-06T07:36:55Z

Setup Tabel

← Older revision		Revision as of 07:36, 6 January 2010
Line 76:		Line 76:
	mysql -u dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/structure.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 dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/data.sql
	mysql -u root -p dms < /var/www/knowledgeTree/sql/mysql/install/user.sql		mysql -u root -p123456 dms < /var/www/knowledgeTree/sql/mysql/install/user.sql

	==Pranala Menarik==		==Pranala Menarik==

Onnowpurbo at 01:49, 21 November 2009

2009-11-21T01:49:04Z

← Older revision		Revision as of 01:49, 21 November 2009
Line 26:		Line 26:
	grant ALL on mahara.* to mahara@localhost identified by 'mahara';		grant ALL on mahara.* to mahara@localhost identified by 'mahara';
	grant ALL on mahara.* to mahara 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 dms;		create database dms;
	grant INSERT,SELECT on root.* to dms@localhost;		grant INSERT,SELECT on root.* to dms@localhost;

Onnowpurbo: /* Setup Tabel */

2009-11-21T01:48:26Z

Setup Tabel

← Older revision		Revision as of 01:48, 21 November 2009
Line 68:		Line 68:
	mysql -u sabily_slta -psisfokol_sabily_slta sisfokol_sabily_slta < /var/www/sisfokol-sabily-sma/db/sep01_1158.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 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 dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/structure.sql		mysql -u dms -pdms dms < /var/www/knowledgeTree/sql/mysql/install/structure.sql

Onnowpurbo at 23:39, 17 November 2009

2009-11-17T23:39:44Z

← Older revision		Revision as of 23:39, 17 November 2009
Line 63:		Line 63:

	mysql -u sisfokol_SD_v2 -psisfokol_SD_v2 sisfokol_SD_v2 < /var/www/sisfokol-sd/db/agust18_0855.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_sltp_v2 -psisfokol_sltp_v2 sisfokol_sltp_v2 < /var/www/sisfokol-smp/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_slta_v2 -psisfokol_slta_v2 sisfokol_slta_v2 < /var/www/sisfokol-sma/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 sisfokol_smk_v2 -psisfokol_smk_v2 sisfokol_smk_v2 < /var/www/sisfokol-smk/db/sept04_1155.sql
	mysql -u sabily_slta -psisfokol_sabily_slta sisfokol_sabily_slta < /var/www/sisfokol-sabily-~~slta~~/db/sep01_1158.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 janissari -psisfokol_janissari_v1 sisfokol_janissari_v1 < /var/www/janissari/db/agust26_1307.sql