Difference between revisions of "Instalasi phpgroupware"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
Line 12: | Line 12: | ||
create database phpgroupware; | create database phpgroupware; | ||
grant INSERT,SELECT on root.* to phpgroupware@localhost; | grant INSERT,SELECT on root.* to phpgroupware@localhost; | ||
− | grant CREATE, INSERT, SELECT, DELETE, UPDATE on phpgroupware.* to | + | grant CREATE, INSERT, SELECT, DELETE, UPDATE on phpgroupware.* to phpgroupware@localhost identified by "phpgroupwarepass"; |
− | grant CREATE, INSERT, SELECT, DELETE, UPDATE on phpgroupware.* to | + | grant CREATE, INSERT, SELECT, DELETE, UPDATE on phpgroupware.* to phpgroupware identified by "phpgroupwarepass"; |
exit | exit | ||
Line 20: | Line 20: | ||
# mysql -u root -p | # mysql -u root -p | ||
Enter password: | Enter password: | ||
− | create database | + | create database phpgroupware; |
− | grant ALL on root.* to | + | grant ALL on root.* to phpgroupware@localhost; |
− | grant ALL on phpgroupware.* to | + | grant ALL on phpgroupware.* to phpgroupware@localhost identified by "phpgroupware"; |
− | grant ALL on phpgroupware.* to | + | grant ALL on phpgroupware.* to phpgroupware identified by "phpgroupware"; |
exit | exit | ||
Revision as of 09:13, 1 November 2010
Siapkan database
Password root MySQL di set sebagai password. Perintah yang digunakan untuk mengkonfigurasi adalah
mysql mysql> SET PASSWORD FOR root@localhost=PASSWORD('password');
Jika password Root MySQL database sudah di set maka kita dapat langsung mengkonfigurasi MySQL menggunakan perintah
# mysql -u root -p Enter password: create database phpgroupware; grant INSERT,SELECT on root.* to phpgroupware@localhost; grant CREATE, INSERT, SELECT, DELETE, UPDATE on phpgroupware.* to phpgroupware@localhost identified by "phpgroupwarepass"; grant CREATE, INSERT, SELECT, DELETE, UPDATE on phpgroupware.* to phpgroupware identified by "phpgroupwarepass"; exit
Jika kita sedang belajar ada baiknya menggunakan perintah berikuta dalam membuat database
# mysql -u root -p Enter password: create database phpgroupware; grant ALL on root.* to phpgroupware@localhost; grant ALL on phpgroupware.* to phpgroupware@localhost identified by "phpgroupware"; grant ALL on phpgroupware.* to phpgroupware identified by "phpgroupware"; exit
Instalasi
apt-get install phpgroupware-0.9.16
Masukan informasi:
- Please enter the desired phpGroupWare 'Header Admin' password: passwordadmin
- Confirm the 'Header Admin' password: passwordadmin
- Please enter the phpGroupWare 'Setup/Config Admin' password: passwordadmin
- Please retype the phpGroupWare 'Setup/Config Admin' password: passwordadmin
- What database type will phpGroupWare use MySQL
- Please enter the database administrator user name: root
- Please enter the database administrator password (if any): passwordrootmysql
- Please enter phpGroupWare database name: phpgroupware___
- Please enter the database user name to access the database: pgpgroupware
- Please enter the password to access the database: pgpgroupware