Difference between revisions of "SMEOnffLine: Setup MySQL untuk Semua CMS"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| (One intermediate revision 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 - | + | # mysql -u root -p123456 |
| − | |||
create database wordpress; | create database wordpress; | ||
| Line 35: | Line 34: | ||
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'; | ||
| − | |||
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 47: | ||
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 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 | ||
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