Changes for page MySQL Installation
Last modified by Thomas Mortagne on 2022/05/25
Change comment:
fixed typo
Summary
-
Page properties (1 modified, 0 added, 0 removed)
-
Objects (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -20,7 +20,7 @@ 20 20 {code} 21 21 mysql -u root -e "grant all privileges on xwiki.* to xwiki@127.0.0.1 identified by 'xwiki'" 22 22 {code} 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> dire dctory 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/].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 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: 25 25 {code} 26 26 <property name="connection.url">jdbc:mysql://localhost/xwiki</property> ... ... @@ -35,3 +35,22 @@ 35 35 mysqld --console --max_allowed_packet=32M 36 36 {code} 37 37 38 +1.1 Troubleshooting 39 + 40 +1.1.1 Can't create test file 41 + 42 +When running <tt>mysqld --console</tt> you may get the following (especially if you're on Mac): 43 + 44 +{code} 45 +071111 17:20:53 [Warning] Can't create test file /usr/local/mysql-5.0.45-osx10.4-i686/data/Vincent.lower-test 46 +071111 17:20:53 [Warning] Can't create test file /usr/local/mysql-5.0.45-osx10.4-i686/data/Vincent.lower-test 47 +mysqld: Can't change dir to '/usr/local/mysql-5.0.45-osx10.4-i686/data/' (Errcode: 13) 48 +071111 17:20:53 [ERROR] Aborting 49 +{code} 50 + 51 +To start MySQL run the following instead: 52 + 53 +{code} 54 +sudo /usr/local/mysql/bin/mysqld_safe --user=mysql 55 +{code} 56 +
- XWiki.XWikiComments[3]
-
- Date
-
... ... @@ -1,1 +1,1 @@ 1 -2007-09-30 01:45:34. 2851 +2007-09-30 01:45:34.0