1 FIXME: these instructions are slightly broken.
3 Installing phpwiki with mySQL
4 -----------------------------
6 This assumes that you have a working mySQL server and client setup.
7 Installing mySQL is beyond the scope of this document.
8 For more information on mySQL go to http://www.mysql.org/
10 1. If you do not have a suitable database already, create one.
12 mysqladmin -uuser -ppassword create phpwiki
14 2. If necessary create a user for that database which has the rights to
15 select, insert, update, delete. A mySQL grant statment for this user
18 GRANT select, insert, update, delete
21 IDENTIFIED BY 'password';
23 3. Create tables inside your database.
25 mysql -uuser -ppassword phpwiki <schemas/schema.mysql
27 Note: the user specified in this command needs to have the rights
28 to drop and create tables. Use the same user as in step 1.
30 If you are using mySQL 3.21.x or earlier the script may issue an
31 error. In that case remove existing tables manually and delete
32 the "drop tables" lines from schemas/schema.mysql - it should work now
34 4. Edit index.php to reflect your settings.
36 a) comment out the DBM settings
37 b) uncomment the mySQL settings
38 c) set $mysql_user to "wikiuser" as used in step 2
39 d) set $mysql_pwd to "password" as used in step 2
40 e) set $mysql_db to "phpwiki" as used in step 1
43 That's it. phpwiki should now work.
45 If you run into problems then check that your mySQL-user has
46 the necessary access rights for the phpwiki tables.
48 Hint for Linux-Debian users: it may be necessary to load the mySQL
49 module first: insert the following line in config.php before
50 "mysql.php" gets included:
51 if (!extension_loaded("mysql")) { dl("mysql.so"); }
56 $Id: INSTALL.mysql,v 1.8 2001-09-18 19:16:23 dairiki Exp $