Changes for page MySQL Installation

Last modified by Thomas Mortagne on 2023/11/16

From version 1.10
edited by Vincent Massol
on 2007/01/22
Change comment: There is no comment for this version
To version 1.11
edited by Vincent Massol
on 2007/07/10
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,7 @@
1 1  1 MySQL Installation
2 2  
3 -Steps:
3 +Follow these instructions:
4 +
4 4  * Download and install [MySQL>http://www.mysql.com/]
5 5  ** Note that XWiki will not work with MySQL version 4.0 or lower as one library we're using (C3P0) is not compatible with MySQL 4.x.
6 6  * Start the MySQL server. You can do that in several ways. For example:
... ... @@ -15,7 +15,8 @@
15 15  {code}
16 16  mysql -u root -e "grant all privileges on xwiki.* to [email protected] identified by 'xwiki'"
17 17  {code}
18 -* Tell XWiki to use MySQL. To do this, edit the ~~WEB-INF/hibernate.cfg.xml~~ file where you have expanded the XWiki WAR file. Replace the matching properties with the following ones:
19 +* You need to have the MySQL JDBC Driver JAR (named <tt>mysql-connector-java*.jar</tt> installed in XWiki's WAR file. If this file isn't present in XWiki's <tt>WEB-INF/lib</tt> diredctory you'll need to download it and copy it there. You can download it from the [MySQL Connector/J Driver page>http://www.mysql.com/products/connector/j/] or directly from the [Maven Central Repository>http://repo1.maven.org/maven2/mysql/mysql-connector-java/].
20 +* Now you need to tell XWiki to use MySQL. To do this, edit the <tt>WEB-INF/hibernate.cfg.xml</tt> file where you have expanded the XWiki WAR file and replace the matching properties with the following ones:
19 19  {code}
20 20  <property name="connection.url">jdbc:mysql://localhost/xwiki</property>
21 21  <property name="connection.username">xwiki</property>

Get Connected