View source for SMEOnffLine: Setup MySQL untuk Semua CMS

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==

* [[SMEOnffLine: Server Berbasis Sabily]]
* [[SMEOnffLine: Server Berbasis Ubuntu]]