| Index: trunk/phpwiki/fpw/README |
| — | — | @@ -67,10 +67,18 @@ |
| 68 | 68 | mysql> source wikipedia.sql; |
| 69 | 69 | in order to create the tables needed. |
| 70 | 70 | |
| | 71 | +The mysql server needs to use the same timezone as php, or else you |
| | 72 | +will later get bogus edit conflicts. Do: |
| | 73 | + $ mysql -u wikiuser |
| | 74 | + mysql> select now(); |
| | 75 | +If the output is different from your current local time, you should |
| | 76 | +start mysqld with the --timezone command line option, or set your TZ |
| | 77 | +environment variable. |
| | 78 | + |
| 71 | 79 | You then need to edit the file wikiLocalSettings.php. Add lines like |
| 72 | 80 | this: |
| 73 | 81 | |
| 74 | | -$wikiThisDBserver = "127.0.0.1"; # the address of the computer running mysqld |
| | 82 | +$wikiThisDBserver = "127.0.0.1"; # the IP address of the computer running mysqld |
| 75 | 83 | $wikiSQLServer = "wikidb"; # the mysql database used for Wikipedia |
| 76 | 84 | $wikiThisDBuser = "wikiuser"; # the mysql user |
| 77 | 85 | $wikiThisDBpassword = "xxx"; # mysql password |