Changes for page MySQL Installation

Last modified by Thomas Mortagne on 2023/11/16

<
From version < 32.2 >
edited by Vincent Massol
on 2015/08/30
To version < 32.3 >
edited by dkl
on 2017/01/06
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.VincentMassol
1 +XWiki.dkl
Content
... ... @@ -22,7 +22,8 @@
22 22  
23 23  * Download and install [[MySQL>>http://www.mysql.com/]] 5.x or greater.
24 24  * Start the MySQL server. You can do that in several ways. For example use {{code}}mysqld --console{{/code}}
25 -* Create the wiki database. You can use the name you want for the database, but you will have to set the hibernate configuration file and ##xwiki.cfg## file accordingly.((( You can create the database in several ways. For example use:
25 +* Create the wiki database. You can use the name you want for the database, but you will have to set the hibernate configuration file and ##xwiki.cfg## file accordingly.(((
26 +You can create the database in several ways. For example use:
26 26  
27 27  {{code}}
28 28  mysql -u root -e "create database xwiki default character set utf8 collate utf8_bin"
... ... @@ -33,6 +33,8 @@
33 33  mysql -u root -e "grant all privileges on *.* to xwiki@localhost identified by 'xwiki'"
34 34  {{/code}}
35 35  )))
37 +* If the above command fails because the password does not meet requirements, uninstall the password_validate plugin:
38 +{{code}}mysql -u root -p -e "uninstall plugin validate_password;"{{/code}}
36 36  * Please make sure that the DNS-name "localhost" is defined in your hosts-file (i.e. ##/etc/hosts##)
37 37  * You need to have the MySQL JDBC Driver JAR (named ##mysql-connector-java*.jar##) installed in XWiki's WAR file. If this file isn't present in XWiki's ##WEB-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/downloads/connector/j/]] or directly from the [[Maven Central Repository>>http://repo1.maven.org/maven2/mysql/mysql-connector-java/]].(((
38 38  {{warning}}
... ... @@ -40,13 +40,15 @@
40 40  {{/warning}}
41 41  )))
42 42  * Now you need to tell XWiki to use MySQL. To do this, edit the ##WEB-INF/hibernate.cfg.xml## file where you have expanded the XWiki WAR file and replace the matching properties with the following ones:(((
43 -{{code language="xml"}}<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
46 +{{code language="xml"}}
47 +<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
44 44  <property name="connection.username">xwiki</property>
45 45  <property name="connection.password">xwiki</property>
46 46  <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
47 47  <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
48 48  <property name="connection.useUnicode">true</property>
49 -<property name="connection.characterEncoding">UTF-8</property>{{/code}}
53 +<property name="connection.characterEncoding">UTF-8</property>
54 +{{/code}}
50 50  
51 51  {{info}}
52 52  * By default MySQL only accepts packets that are 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 {{code}}mysqld --console --max_allowed_packet=32M{{/code}} or you can modify directly the ##my.cnf## configuration file to set this value permanently.
... ... @@ -224,6 +224,7 @@
224 224  If this is the case [[you need to tell XWiki that you're using a different schema by setting the ##xwiki.db## configuration property>>AdminGuide.Configuration#HConfigurethenamesofdatabaseschemas]].
225 225  
226 226  == MySQLSyntaxErrorException: Row size too large (> 8126) ==
232 +
227 227  if you get the following error:
228 228  
229 229  {{code language="none"}}

Get Connected