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

From OnnoWiki
Jump to navigation Jump to search
(New page: 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,SELEC...)
 
 
(10 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: <123456>
 
  
 
  create database wordpress;
 
  create database wordpress;
Line 12: Line 11:
 
  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;
Line 17: Line 23:
 
  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";
 +
create database joomla;
 +
grant ALL on joomla.* to joomla@localhost 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';
 +
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;
 +
drop database weberpdemo;
 
  exit
 
  exit
  
Line 24: Line 45:
 
==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
  
 +
mysqladmin --user=root --password=123456 --force drop weberpdemo
 +
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
  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==
  
* [[SMEOnffLine: Server Berbasis Sabily 9.04]]
+
* [[SMEOnffLine: Server Berbasis Sabily]]
* [[SMEOnffLine: Server Berbasis Ubuntu 9.04]]
+
* [[SMEOnffLine: Server Berbasis Ubuntu]]

Latest revision as of 11:15, 6 May 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 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;
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 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";
create database joomla;
grant ALL on joomla.* to joomla@localhost 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';
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;
drop database weberpdemo;
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

mysqladmin --user=root --password=123456 --force drop weberpdemo
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/data.sql
mysql -u root -p123456 dms < /var/www/knowledgeTree/sql/mysql/install/user.sql

Pranala Menarik