2 Installing phpwiki with mySQL
3 -----------------------------
5 This assumes that you have a working mySQL server and client setup.
6 Installing mySQL is beyond the scope of this document.
7 For more information on mySQL go to http://www.mysql.org/
9 1. If you do not have a suitable database already, create one.
11 mysqladmin -uuser -ppaswword create phpwiki
13 2. If necessary create a user for that database which has the rights to
14 select, insert, update, delete. A mySQL grant statment for this user
17 GRANT select, insert, update, delete
20 IDENTIFIED BY 'password';
22 3. Create tables inside your database.
25 page varchar(100) primary key,
28 CREATE table archive (
29 page varchar(100) primary key,
32 4. Edit wiki_config.php3 to reflect your settings.
34 a) comment out the DBM settings
35 b) uncomment the mySQL settings
36 c) set $mysql_user to "wikiuser" as used in step 2
37 d) set $mysql_pwd to "password" as used in step 2
38 e) set $mysql_db to "phpwiki" as used in step 1
39 f) set MAX_DBM_ATTEMPTS to a low number or to '1'.
40 Retrying has not much sense when using mySQL.
44 That's it. phpwiki should now work.
46 If you run into problems then check that your mySQL-user has
47 the necessary access rights for the phpwiki tables.
53 $Id: INSTALL.mysql,v 1.2 2000-06-08 22:11:05 ahollosi Exp $