Changes for page MySQL Installation

Last modified by Thomas Mortagne on 2022/05/25
<
From version < 1.21 >
edited by AkiBackman
on 2007/11/22
To version < 1.22 >
edited by AkiBackman
on 2007/11/22
>
Change comment: Rollback to version 1.18

Summary

Details

Page properties
Content
... ... @@ -1,6 +1,7 @@
1 1  1 MySQL Installation
2 2  
3 3  #toc("" "" "")
4 +
4 4  1.1 Installation Steps
5 5  
6 6  Follow these instructions:
... ... @@ -8,39 +8,30 @@
8 8  * Download and install [MySQL>http://www.mysql.com/]
9 9  ** 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.
10 10  * Start the MySQL server. You can do that in several ways. For example:
11 -
12 12  {code}
13 -mysqld &#45;&#45;console
13 +mysqld --console
14 14  {code}
15 -
16 16  * Create the wiki database. You can do that in several ways. For example:
17 -
18 18  {code}
19 -mysql &#45;u root &#45;e "create database xwiki"
17 +mysql -u root -e "create database xwiki"
20 20  {code}
21 -
22 22  * Give all privileges to the xwiki user for accessing the xwiki database. You can do that in several ways. For example (if you get connections problems try localhost instead of the IP address below):
23 -
24 24  {code}
25 -<span style="font-size: 10px">mysql &#45;u root &#45;e "grant all privileges on xwiki.&#42; to xwiki@127.0.0.1 identified by 'xwiki'"
26 -</span>
21 +mysql -u root -e "grant all privileges on xwiki.* to xwiki@127.0.0.1 identified by 'xwiki'"
27 27  {code}
28 -
29 -* You need to have the MySQL JDBC Driver JAR (named mysql&#45;connector&#45;java&#42;.jar installed in XWiki's WAR file. If this file isn't present in XWiki's WEB&#45;INF/lib directory 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/].
30 -* Now you need to tell XWiki to use MySQL. To do this, edit the WEB&#45;INF/hibernate.cfg.xml file where you have expanded the XWiki WAR file and replace the matching properties with the following ones:
31 -
23 +* 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> directory 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/].
24 +* 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:
32 32  {code}
33 33  <property name="connection.url">jdbc:mysql://localhost/xwiki</property>
34 34  <property name="connection.username">xwiki</property>
35 35  <property name="connection.password">xwiki</property>
36 -<property name="connection.driver&#95;class">com.mysql.jdbc.Driver</property>
29 +<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
37 37  <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
38 38  {code}
39 39  
40 -Note: By default MySQL only accepts packets smaller than 1MB. If you get the "Packet for query is too large (max&#95;allowed&#95;packet)" error then see the [Packet too large error page>http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html]. For example to increase the packet size to 32M you could start the MySQL server with:
41 -
33 +Note: By default MySQL only accepts packets smaller than 1MB. If you get the "Packet for query is too large (max_allowed_packet)" error then see the [Packet too large error page>http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html]. For example to increase the packet size to 32M you could start the MySQL server with:
42 42  {code}
43 -mysqld &#45;&#45;console &#45;&#45;max&#95;allowed&#95;packet=32M
35 +mysqld --console --max_allowed_packet=32M
44 44  {code}
45 45  
46 46  1.1 Troubleshooting
XWiki.XWikiComments[1]
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.amitjain44
1 +xwiki:XWiki.brandone
Comment
... ... @@ -1,5 +1,1 @@
1 -Specifying Packet size when running MYSQL as service:
2 -For windows invoke services utility which lists all the service configured on your window platform.Go to MySQL service configuration. On "General Tab" we can find the file used by the MySQL service to load the parameters. For eg. in my case it is
3 -"d:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="d:\Program Files\MySQL\MySQL Server 5.0\my.ini".
4 -Add following line to configure size to 64M.
5 -max_allowed_packet=64M
1 +I use the MySQL Administrator tool *almost* exclusively with MySQL tasks. It used to be a pain to work with (for example, disabled fields when they were not in the ini), but as at recent revisions (r8 in particular), this is no longer a problem.
Date
... ... @@ -1,1 +1,1 @@
1 -2007-01-17 11:46:35.0
1 +2007-01-17 14:12:05.0
XWiki.XWikiComments[2]
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.brandone
1 +Search
Comment
... ... @@ -1,1 +1,1 @@
1 -I use the MySQL Administrator tool *almost* exclusively with MySQL tasks. It used to be a pain to work with (for example, disabled fields when they were not in the ini), but as at recent revisions (r8 in particular), this is no longer a problem.
1 +In Linux add the line to /etc/my.cnf
Date
... ... @@ -1,1 +1,1 @@
1 -2007-01-17 14:12:05.0
1 +2007-09-30 01:45:34.0
XWiki.XWikiComments[3]
Author
... ... @@ -1,1 +1,0 @@
1 -Search
Comment
... ... @@ -1,1 +1,0 @@
1 -In Linux add the line to /etc/my.cnf
Date
... ... @@ -1,1 +1,0 @@
1 -2007-09-30 01:45:34.0
XWiki.XWikiComments[0]
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.amitjain44
Comment
... ... @@ -1,0 +1,5 @@
1 +Specifying Packet size when running MYSQL as service:
2 +For windows invoke services utility which lists all the service configured on your window platform.Go to MySQL service configuration. On "General Tab" we can find the file used by the MySQL service to load the parameters. For eg. in my case it is
3 +"d:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="d:\Program Files\MySQL\MySQL Server 5.0\my.ini".
4 +Add following line to configure size to 64M.
5 +max_allowed_packet=64M
Date
... ... @@ -1,0 +1,1 @@
1 +2007-01-17 11:46:35.0

About

About

Support

Platform

User Guide

Admin Guide

Developer Guide

Projects

XWiki

Extensions

Other

Contribute

Status

Practices

Under the Hood

Get Involved

Get Connected