SchoolOnffLine: Setup MySQL untuk Semua CMS
Jump to navigation
Jump to search
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 moodle; grant INSERT,SELECT on root.* to moodle@localhost; grant ALL on moodle.* to moodle@localhost identified by "moodle"; grant ALL on moodle.* to moodle identified by "moodle"; create database senayan; GRANT ALL PRIVILEGES ON senayan.* TO 'senayan'@'localhost' IDENTIFIED BY 'senayan'; GRANT ALL PRIVILEGES ON senayan.* TO 'senayan' IDENTIFIED BY 'senayan'; 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 cmsbalitbang; grant INSERT,SELECT on root.* to cmsbalitbang@localhost; grant ALL on cmsbalitbang.* to cmsbalitbang@localhost identified by 'cmsbalitbang'; grant ALL on cmsbalitbang.* to cmsbalitbang identified by 'cmsbalitbang';
create database sisfokol_sd; GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd'@'localhost' IDENTIFIED BY 'sisfokol_sd'; GRANT ALL PRIVILEGES ON sisfokol_sd.* TO 'sisfokol_sd' IDENTIFIED BY 'sisfokol_sd'; create database sisfokol_sltp; GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp'@'localhost' IDENTIFIED BY 'sisfokol_sltp'; GRANT ALL PRIVILEGES ON sisfokol_sltp.* TO 'sisfokol_sltp' IDENTIFIED BY 'sisfokol_sltp'; create database sisfokol_slta; GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta'@'localhost' IDENTIFIED BY 'sisfokol_slta'; GRANT ALL PRIVILEGES ON sisfokol_slta.* TO 'sisfokol_slta' IDENTIFIED BY 'sisfokol_slta'; create database sisfokol_smk; GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk'@'localhost' IDENTIFIED BY 'sisfokol_smk'; GRANT ALL PRIVILEGES ON sisfokol_smk.* TO 'sisfokol_smk' IDENTIFIED BY 'sisfokol_smk'; create database sisfokol_sabily_slta; GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta'@'localhost' IDENTIFIED BY 'sisfokol_sabily_slta'; GRANT ALL PRIVILEGES ON sisfokol_sabily_slta.* TO 'sabily_slta' IDENTIFIED BY 'sisfokol_sabily_slta'; create database sisfokol_janissari_v1; GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari'@'localhost' IDENTIFIED BY 'sisfokol_janissari_v1'; GRANT ALL PRIVILEGES ON sisfokol_janissari_v1.* TO 'janissari' IDENTIFIED BY 'sisfokol_janissari_v1'; 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 senayan -psenayan senayan < /var/www/senayan/install/senayan.sql mysql -u senayan -psenayan senayan < /var/www/senayan/install/sample_data.sql mysql -u sisfokol_sd -psisfokol_sd sisfokol_sd < /var/www/sisfokol-sd/db/sisfokol.sql mysql -u sisfokol_sltp -psisfokol_sltp sisfokol_sltp < /var/www/sisfokol-smp/db/sisfokol.sql mysql -u sisfokol_slta -psisfokol_slta sisfokol_slta < /var/www/sisfokol-sma/db/sisfokol.sql mysql -u sisfokol_smk -psisfokol_smk sisfokol_smk < /var/www/sisfokol-smk/db/sisfokol.sql mysql -u sabily_slta -psisfokol_sabily_slta sisfokol_sabily_slta < /var/www/sisfokol-sabily-sma/db/sep01_1158.sql mysql -u janissari -psisfokol_janissari_v1 sisfokol_janissari_v1 < /var/www/janissari/db/agust26_1307.sql mysql -u cmsbalitbang -pcmsbalitbang cmsbalitbang < /var/www/cmsbalitbang/sql-cms.sql
mysql -u root -p123456 < /var/www/epi/project_db.sql
Pranala Menarik
- Mengatasi Masalah Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Remaster Ubuntu untuk SchoolOnffLine Menggunakan UCK
- SchoolOnffLine: Server Berbasis Sabily 9.04
- SchoolOnffLine: Server Berbasis Ubuntu 9.04
- SchoolOnffLine: Server Berbasis Ubuntu
- SchoolOnffLine: Server Berbasis Ubuntu 9.04 Alternate
- SchoolOnffLine: Server Berbasis Ubuntu 9.04 Server
- SchoolOnffLine: Server Wikipedia for School
- Remastering Ubuntu