SMEOnffLine: Setup MySQL untuk Semua CMS

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';
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

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

Pranala Menarik

• SMEOnffLine: Server Berbasis Sabily
• SMEOnffLine: Server Berbasis Ubuntu