From: Geoffrey T. D. <da...@us...> - 2001-11-09 04:50:33
|
Update of /cvsroot/phpwiki/phpwiki In directory usw-pr-cvs1:/tmp/cvs-serv22974 Modified Files: INSTALL.mysql Log Message: Documentation fixes based on SF patch #479791 by Carsten Klapp. Index: INSTALL.mysql =================================================================== RCS file: /cvsroot/phpwiki/phpwiki/INSTALL.mysql,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -r1.8 -r1.9 *** INSTALL.mysql 2001/09/18 19:16:23 1.8 --- INSTALL.mysql 2001/11/09 04:50:30 1.9 *************** *** 8,19 **** For more information on mySQL go to http://www.mysql.org/ ! 1. If you do not have a suitable database already, create one. mysqladmin -uuser -ppassword create phpwiki ! 2. If necessary create a user for that database which has the rights to ! select, insert, update, delete. A mySQL grant statment for this user ! would look like this: ! GRANT select, insert, update, delete ON phpwiki.* --- 8,25 ---- For more information on mySQL go to http://www.mysql.org/ ! 1. If you do not have a suitable database already, create one (using ! the root or other privileged account you set up when mySQL was ! installed.) mysqladmin -uuser -ppassword create phpwiki ! 2. If necessary create a user for that database which has the rights ! to select, insert, update, delete (again using the root ! administration account). ! ! mysql -uuser -ppassword phpwiki ! ! A mySQL grant statement for this user would look like this: ! GRANT select, insert, update, delete ON phpwiki.* *************** *** 21,25 **** IDENTIFIED BY 'password'; ! 3. Create tables inside your database. mysql -uuser -ppassword phpwiki <schemas/schema.mysql --- 27,31 ---- IDENTIFIED BY 'password'; ! 3. Create tables inside your database (still using the root account). mysql -uuser -ppassword phpwiki <schemas/schema.mysql *************** *** 31,43 **** error. In that case remove existing tables manually and delete the "drop tables" lines from schemas/schema.mysql - it should work now - - 4. Edit index.php to reflect your settings. ! a) comment out the DBM settings ! b) uncomment the mySQL settings ! c) set $mysql_user to "wikiuser" as used in step 2 ! d) set $mysql_pwd to "password" as used in step 2 ! e) set $mysql_db to "phpwiki" as used in step 1 That's it. phpwiki should now work. --- 37,51 ---- error. In that case remove existing tables manually and delete the "drop tables" lines from schemas/schema.mysql - it should work now ! 4. Edit $DBParams in index.php to reflect your settings. + a) $DBParams['dbtype'] should be set to 'SQL'. + b) $DBParams['dsn'] should be set to something like + 'mysql://username:password@host/phpwiki'. + (where 'phpwiki' is the mysql database name.) + c) Note that if you set $DBParams['prefix'] to a + non-empty string, you will have to edit + schemas/schema.mysql before you perform step + three (above). (Sorry.) That's it. phpwiki should now work. |