Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -27,7 +27,7 @@
27	27	Follow these instructions:
28	28
29	29	* Download and install [[MySQL>>http://www.mysql.com/]] 5.x or greater.
30		-* Start the MySQL server. You can do that in several ways. For example use {{code}}mysqld --console{{/code}}
	30	+* Start the MySQL server. You can do that in several ways. For example use {{code language='shell'}}mysqld --console{{/code}}
31	31	* 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.(((
32	32	You can create the database in several ways. For example use:
33	33
...	...	@@ -40,7 +40,7 @@
40	40	mysql -u root -e "CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'xwiki'";
41	41	{{/code}}
42	42	)))
43		-* Give privileges to the ##xwiki## user for accessing and creating databases (for the multi wiki support). Specifically the ##xwiki## users needs permissions to be able to execute {{code}}CREATE DATABASE{{/code}}, {{code}}DROP SCHEMA{{/code}}, and then all CRUD operations on tables. Note that the command below should be tuned to be more restrictive as granting all permissions is not required:(((
	43	+* Give privileges to the ##xwiki## user for accessing and creating databases (for the multi wiki support). Specifically the ##xwiki## users needs permissions to be able to execute {{code language='sql'}}CREATE DATABASE{{/code}}, {{code language='sql'}}DROP SCHEMA{{/code}}, and then all CRUD operations on tables. Note that the command below should be tuned to be more restrictive as granting all permissions is not required:(((
44	44	{{code language='shell'}}
45	45	mysql -u root -e "grant all privileges on *.* to xwiki@localhost"
46	46	{{/code}}
...	...	@@ -68,7 +68,7 @@
68	68	{{/code}}
69	69
70	70	{{info}}
71		-* 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.
	71	+* 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 language='shell'}}mysqld --console --max_allowed_packet=32M{{/code}} or you can modify directly the ##my.cnf## configuration file to set this value permanently.
72	72	* If an empty XWiki starts with no errors, but you are unable to upload the default set of pages (XAR file) try to increase the ##max_allowed_packet## parameter as shown above.
73	73	{{/info}}
74	74	)))