Difference between revisions of "Instalasi phpgroupware"

From OnnoWiki
Jump to navigation Jump to search
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 phpgroupware___@localhost identified by "phpgroupwarepass";
+
  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";
+
  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 phpgroupware__;
+
  create database phpgroupware;
  grant ALL on root.* to phpgroupware__@localhost;
+
  grant ALL on root.* to phpgroupware@localhost;
  grant ALL on phpgroupware.* to phpgroupware__@localhost identified by "phpgroupware";
+
  grant ALL on phpgroupware.* to phpgroupware@localhost identified by "phpgroupware";
  grant ALL on phpgroupware.* to phpgroupware__ identified by "phpgroupware";
+
  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


Pranala Menarik