Instalasi phpgroupware

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 vsftpd

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