SMEOnffLine: Setup MySQL untuk Semua CMS
Revision as of 13:24, 12 November 2009 by Onnowpurbo (talk | contribs)
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,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'; 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
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 -p dms < /var/www/knowledgeTree/sql/mysql/install/user.sql