SMEOnffLine: Setup MySQL untuk Semua CMS - Revision history

Onnowpurbo at 04:15, 6 May 2010

2010-05-06T04:15:36Z

← Older revision		Revision as of 04:15, 6 May 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;

Onnowpurbo at 03:56, 13 January 2010

2010-01-13T03:56:25Z

← Older revision		Revision as of 03:56, 13 January 2010
Line 35:		Line 35:
	grant ALL on prestashop.* to prestashop@localhost identified by 'prestashop';		grant ALL on prestashop.* to prestashop@localhost identified by 'prestashop';
	grant ALL on prestashop.* to prestashop identified by 'prestashop';		grant ALL on prestashop.* to prestashop identified by 'prestashop';
	~~drop database weberpdemo;~~
	create database weberpdemo;		create database weberpdemo;
	grant INSERT,SELECT on root.* to weberp@localhost;		grant INSERT,SELECT on root.* to weberp@localhost;
	SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');		SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
	GRANT ALL PRIVILEGES ON . TO weberp@localhost IDENTIFIED BY 'weberp' WITH GRANT OPTION;		GRANT ALL PRIVILEGES ON . TO weberp@localhost IDENTIFIED BY 'weberp' WITH GRANT OPTION;
			drop database weberpdemo;
	exit		exit

Line 48:		Line 48:
	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

			mysqladmin --user=root --password=123456 --force drop weberpdemo
	mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql		mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql
	~~mysql -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.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
	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

Onnowpurbo: /* Setup Tabel */

2010-01-13T03:54:41Z

Setup Tabel

← Older revision		Revision as of 03:54, 13 January 2010
Line 49:		Line 49:

	mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql		mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql
	mysql -u weberp -pweberp ~~weberp~~ < /var/www/webERP/sql/mysql/weberp-demo.sql		mysql -u weberp -pweberp weberpdemo < /var/www/webERP/sql/mysql/weberp-demo.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
	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

Onnowpurbo: /* Setup Tabel */

2010-01-13T03:54:01Z

Setup Tabel

← Older revision		Revision as of 03:54, 13 January 2010
Line 46:		Line 46:
	==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 --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql		mysql --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.sql
			mysql -u weberp -pweberp weberp < /var/www/webERP/sql/mysql/weberp-demo.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
	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

Onnowpurbo at 03:19, 11 January 2010

2010-01-11T03:19:19Z

← Older revision		Revision as of 03:19, 11 January 2010
Line 35:		Line 35:
	grant ALL on prestashop.* to prestashop@localhost identified by 'prestashop';		grant ALL on prestashop.* to prestashop@localhost identified by 'prestashop';
	grant ALL on prestashop.* to prestashop identified by 'prestashop';		grant ALL on prestashop.* to prestashop identified by 'prestashop';
			drop database weberpdemo;
			create database weberpdemo;
			grant INSERT,SELECT on root.* to weberp@localhost;
			SET PASSWORD FOR weberp@localhost=PASSWORD('weberp');
			GRANT ALL PRIVILEGES ON . TO weberp@localhost IDENTIFIED BY 'weberp' WITH GRANT OPTION;
	exit		exit

Line 43:		Line 48:
	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 --user=weberp --password='weberp' < /var/www/webERP/sql/mysql/weberp-demo.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
	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

Onnowpurbo: /* Setup Tabel */

2010-01-07T00:59:49Z

Setup Tabel

← Older revision		Revision as of 00:59, 7 January 2010
Line 45:		Line 45:
	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 00:02, 21 November 2009

2009-11-21T00:02:21Z

← Older revision		Revision as of 00:02, 21 November 2009
Line 31:		Line 31:
	grant ALL on joomla.* to joomla@localhost identified by 'joomla';		grant ALL on joomla.* to joomla@localhost identified by 'joomla';
	grant ALL on joomla.* to joomla identified by 'joomla';		grant ALL on joomla.* to joomla identified by 'joomla';
			create database prestashop;
			grant ALL on root.* to prestashop@localhost;
			grant ALL on prestashop.* to prestashop@localhost identified by 'prestashop';
			grant ALL on prestashop.* to prestashop identified by 'prestashop';
	exit		exit

Onnowpurbo at 23:59, 20 November 2009

2009-11-20T23:59:10Z

← Older revision		Revision as of 23:59, 20 November 2009
Line 28:		Line 28:
	grant ALL on egroupware.* to egroupware@localhost identified by "egroupware";		grant ALL on egroupware.* to egroupware@localhost identified by "egroupware";
	grant ALL on egroupware.* to egroupware identified by "egroupware";		grant ALL on egroupware.* to egroupware identified by "egroupware";
			create database joomla;
			grant ALL on joomla.* to joomla@localhost identified by 'joomla';
			grant ALL on joomla.* to joomla identified by 'joomla';
	exit		exit

Onnowpurbo at 06:26, 12 November 2009

2009-11-12T06:26:40Z

← Older revision		Revision as of 06:26, 12 November 2009
Line 24:		Line 24:
	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';		grant ALL on dms.* to dms identified by 'dms';
			create database egroupware;
			grant ALL on root.* to egroupware@localhost;
			grant ALL on egroupware.* to egroupware@localhost identified by "egroupware";
			grant ALL on egroupware.* to egroupware identified by "egroupware";
	exit		exit

Onnowpurbo at 06:24, 12 November 2009

2009-11-12T06:24:22Z

← Older revision		Revision as of 06:24, 12 November 2009
Line 12:		Line 12:
	grant ALL on mediawiki.* to mediawiki@localhost identified by 'mediawiki';		grant ALL on mediawiki.* to mediawiki@localhost identified by 'mediawiki';
	grant ALL on mediawiki.* to mediawiki identified by 'mediawiki';		grant ALL on mediawiki.* to mediawiki identified by 'mediawiki';
			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 waypointhr;
			grant INSERT,SELECT on root.* to waypointhr@localhost;
			grant ALL on waypointhr.* to waypointhr@localhost identified by 'waypointhr';
			grant ALL on waypointhr.* to waypointhr identified by 'waypointhr';
	create database dms;		create database dms;
	grant INSERT,SELECT on root.* to dms@localhost;		grant INSERT,SELECT on root.* to dms@localhost;