Author: jmesnil Date: 2009-08-21 11:15:06 -0400 (Fri, 21 Aug 2009) New Revision: 7870 Modified: trunk/examples/javaee/ejb-jms-transaction/readme.html Log: added footnote with instructions to setup MySQL for this example Modified: trunk/examples/javaee/ejb-jms-transaction/readme.html =================================================================== --- trunk/examples/javaee/ejb-jms-transaction/readme.html 2009-08-21 14:46:07 UTC (rev 7869) +++ trunk/examples/javaee/ejb-jms-transaction/readme.html 2009-08-21 15:15:06 UTC (rev 7870) @@ -39,7 +39,7 @@ <li>copy <a href="config/mysql-ds.xml"><code>mysql-ds.xml</a></code> to to the profile</li> </ul> - <p>MySQL is configured to connect to a <code>jbossdb</code> database using the <code>jboss</code>/<code>jboss</code> credentials + <p>MySQL is configured to connect to a <code>jbossdb</code> database using the <code>jboss</code>/<code>jboss</code> credentials<a href="#fn1" id="fnr1">¹</a>. <p>MySQL configuration file defines two DataSources:</p> <ul> <li><code>DefaultDS</code>, the default DataSource (used to create a table from the example)</li> @@ -224,5 +224,18 @@ <li><a href="http://www.jboss.org/file-access/default/members/jbossas/freez... Alternative Databases with JBoss AS</a></li> </ul> + <hr> + + <ol> + <li><a name="fn1">Steps to create the MySQL DB</a><a href="#fnr1">&#8617;</a> + <ul> + <li>connect as root to MySQL: <code>mysql</code> + <li>create database jbossdb: <code>create database jbossdb;</code> + <li>create user jboss/jboss: <code>GRANT ALL PRIVILEGES ON *.* TO 'jboss'@'%' IDENTIFIED BY 'jboss' WITH GRANT OPTION;</code> + <li>disconnect from MySQL + <li>check it works: <code>mysql -u jboss -p jbossdb</code> (and type <code>jboss</code> when prompted for the password) + </ul> + </li> + </ol> </body> </html> \ No newline at end of file