https://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&action=history&feed=atomConfiguring MySQL using JDBC and NeoOffice 2.x - Revision history2024-03-29T11:53:26ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=11194&oldid=prevSardisson: Configuring MySQL using JDBC and NeoOffice 2.0 moved to Configuring MySQL using JDBC and NeoOffice 2.x: Make this 2.x2007-07-24T01:55:47Z<p><a href="/index.php/Configuring_MySQL_using_JDBC_and_NeoOffice_2.0" title="Configuring MySQL using JDBC and NeoOffice 2.0">Configuring MySQL using JDBC and NeoOffice 2.0</a> moved to <a href="/index.php/Configuring_MySQL_using_JDBC_and_NeoOffice_2.x" title="Configuring MySQL using JDBC and NeoOffice 2.x">Configuring MySQL using JDBC and NeoOffice 2.x</a>: Make this 2.x</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:55, 24 July 2007</td>
</tr>
</table>Sardissonhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=8319&oldid=prevJgd: botlangbar -> FR2007-01-15T16:26:09Z<p>botlangbar -> FR</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 16:26, 15 January 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 54:</strong></td>
<td colspan="2" align="left"><strong>Line 54:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">You are now ready to create queries and forms that use your MySQL database.</td><td> </td><td style="background: #eee; font-size: smaller;">You are now ready to create queries and forms that use your MySQL database.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">{{botlangbarEN|[[Fr:Configurer_MySQL_avec_JDBC_et_NeoOffice_2.0|Français]]}}</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=7548&oldid=prevAmayze: /* Installation */2006-12-16T12:57:39Z<p><span class="autocomment">Installation</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:57, 16 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 18:</strong></td>
<td colspan="2" align="left"><strong>Line 18:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Installation===</td><td> </td><td style="background: #eee; font-size: smaller;">===Installation===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).</td><td> </td><td style="background: #eee; font-size: smaller;"># If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"># Download the latest version of Connector/J from the [http://dev.mysql.com/downloads/connector/j/<del style="color: red; font-weight: bold; text-decoration: none;">5.0.html </del>MySQL website] and save it to the Desktop. (I downloaded v5.0.4, the tar.gz version).</td><td>+</td><td style="background: #cfc; font-size: smaller;"># Download the latest version of Connector/J from the [http://dev.mysql.com/downloads/connector/j/ MySQL website] and save it to the Desktop. (I downloaded v5.0.4, the tar.gz version).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps <tt>~/Library/MySQL/</tt> for personal use, or <tt>/Library/MySQL/</tt> for all users of the Mac).</td><td> </td><td style="background: #eee; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps <tt>~/Library/MySQL/</tt> for personal use, or <tt>/Library/MySQL/</tt> for all users of the Mac).</td></tr>
</table>Amayzehttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=7547&oldid=prevAmayze: /* Installation */2006-12-16T12:57:16Z<p><span class="autocomment">Installation</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:57, 16 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 18:</strong></td>
<td colspan="2" align="left"><strong>Line 18:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Installation===</td><td> </td><td style="background: #eee; font-size: smaller;">===Installation===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).</td><td> </td><td style="background: #eee; font-size: smaller;"># If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"># Download the latest version of Connector/J from http://<del style="color: red; font-weight: bold; text-decoration: none;">www</del>.mysql.com and save it to the Desktop. (I downloaded v5.0.4, the tar.gz version).</td><td>+</td><td style="background: #cfc; font-size: smaller;"># Download the latest version of Connector/J from <ins style="color: red; font-weight: bold; text-decoration: none;">the [</ins>http://<ins style="color: red; font-weight: bold; text-decoration: none;">dev</ins>.mysql.com<ins style="color: red; font-weight: bold; text-decoration: none;">/downloads/connector/j/5.0.html MySQL website] </ins>and save it to the Desktop. (I downloaded v5.0.4, the tar.gz version).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps <tt>~/Library/MySQL/</tt> for personal use, or <tt>/Library/MySQL/</tt> for all users of the Mac).</td><td> </td><td style="background: #eee; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps <tt>~/Library/MySQL/</tt> for personal use, or <tt>/Library/MySQL/</tt> for all users of the Mac).</td></tr>
</table>Amayzehttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=7546&oldid=prevAmayze: /* Installation */2006-12-16T12:55:13Z<p><span class="autocomment">Installation</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:55, 16 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 18:</strong></td>
<td colspan="2" align="left"><strong>Line 18:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Installation===</td><td> </td><td style="background: #eee; font-size: smaller;">===Installation===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).</td><td> </td><td style="background: #eee; font-size: smaller;"># If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"># Download Connector/J <del style="color: red; font-weight: bold; text-decoration: none;">3.1 </del>from http://www.mysql.com and save it to the Desktop. (I downloaded <del style="color: red; font-weight: bold; text-decoration: none;">v3</del>.<del style="color: red; font-weight: bold; text-decoration: none;">1</del>.<del style="color: red; font-weight: bold; text-decoration: none;">13</del>, the tar.gz version).</td><td>+</td><td style="background: #cfc; font-size: smaller;"># Download <ins style="color: red; font-weight: bold; text-decoration: none;">the latest version of </ins>Connector/J from http://www.mysql.com and save it to the Desktop. (I downloaded <ins style="color: red; font-weight: bold; text-decoration: none;">v5</ins>.<ins style="color: red; font-weight: bold; text-decoration: none;">0</ins>.<ins style="color: red; font-weight: bold; text-decoration: none;">4</ins>, the tar.gz version).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps <tt>~/Library/MySQL/</tt> for personal use, or <tt>/Library/MySQL/</tt> for all users of the Mac).</td><td> </td><td style="background: #eee; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps <tt>~/Library/MySQL/</tt> for personal use, or <tt>/Library/MySQL/</tt> for all users of the Mac).</td></tr>
<tr><td colspan="2" align="left"><strong>Line 27:</strong></td>
<td colspan="2" align="left"><strong>Line 27:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># This opens the "Class Path" window. Make sure that there are no other Connector/J versions installed (e.g., 3.0) or they will make life messy. To remove them, click the jar file to select, then click Remove. Repeat as necessary. (Note: not all items here are necessarily Connector/J archives, use some caution).</td><td> </td><td style="background: #eee; font-size: smaller;"># This opens the "Class Path" window. Make sure that there are no other Connector/J versions installed (e.g., 3.0) or they will make life messy. To remove them, click the jar file to select, then click Remove. Repeat as necessary. (Note: not all items here are necessarily Connector/J archives, use some caution).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Click the "Add Archive…" button.</td><td> </td><td style="background: #eee; font-size: smaller;"># Click the "Add Archive…" button.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"># Browse to the directory where you installed the Connector/J <del style="color: red; font-weight: bold; text-decoration: none;">3.1 </del>jar file (in step 4). Select the .jar file and click the "Open" button.</td><td>+</td><td style="background: #cfc; font-size: smaller;"># Browse to the directory where you installed the Connector/J jar file (in step 4). Select the .jar file and click the "Open" button.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Click the "OK" button.</td><td> </td><td style="background: #eee; font-size: smaller;"># Click the "OK" button.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Exit NeoOffice.</td><td> </td><td style="background: #eee; font-size: smaller;"># Exit NeoOffice.</td></tr>
</table>Amayzehttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=7545&oldid=prevAmayze: /* Usage */2006-12-16T12:47:23Z<p><span class="autocomment">Usage</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:47, 16 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 52:</strong></td>
<td colspan="2" align="left"><strong>Line 52:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Click '''Finish''' and choose a name and location to save the database.</td><td> </td><td style="background: #eee; font-size: smaller;"># Click '''Finish''' and choose a name and location to save the database.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">You are now <del style="color: red; font-weight: bold; text-decoration: none;">read </del>to create queries and forms that use your MySQL database.</td><td>+</td><td style="background: #cfc; font-size: smaller;">You are now <ins style="color: red; font-weight: bold; text-decoration: none;">ready </ins>to create queries and forms that use your MySQL database.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>Amayzehttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=6555&oldid=prevSardisson: fix stray space2006-08-27T05:11:11Z<p>fix stray space</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 05:11, 27 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{handbook sidebar|DatabaseTOC}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{handbook sidebar|DatabaseTOC}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">While NeoOffice 2.0 and higher include the new “Base†database component, many people have existing MySQL databases they would like to use with NeoOffice to enter or manipulate data, including creating detailed forms and reports. This article contains information on installing, configuring, and using a MySQL database with NeoOffice 2.0 using a JDBC driver.</td><td> </td><td style="background: #eee; font-size: smaller;">While NeoOffice 2.0 and higher include the new “Base†database component, many people have existing MySQL databases they would like to use with NeoOffice to enter or manipulate data, including creating detailed forms and reports. This article contains information on installing, configuring, and using a MySQL database with NeoOffice 2.0 using a JDBC driver.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>Sardissonhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=6551&oldid=prevSardisson: /* Installation */ a couple of style guide nits2006-08-27T04:55:51Z<p><span class="autocomment">Installation -</span> a couple of style guide nits</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 04:55, 27 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 21:</strong></td>
<td colspan="2" align="left"><strong>Line 21:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Download Connector/J 3.1 from http://www.mysql.com and save it to the Desktop. (I downloaded v3.1.13, the tar.gz version).</td><td> </td><td style="background: #eee; font-size: smaller;"># Download Connector/J 3.1 from http://www.mysql.com and save it to the Desktop. (I downloaded v3.1.13, the tar.gz version).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td><td> </td><td style="background: #eee; font-size: smaller;"># Extract the Connector/J jar from the tar.gz archive.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps ~/Library/MySQL/ for personal use, or /Library/MySQL/ for all users of the Mac).</td><td>+</td><td style="background: #cfc; font-size: smaller;"># Copy the .jar file to wherever you like (Perhaps <ins style="color: red; font-weight: bold; text-decoration: none;"><tt></ins>~/Library/MySQL/<ins style="color: red; font-weight: bold; text-decoration: none;"></tt> </ins>for personal use, or <ins style="color: red; font-weight: bold; text-decoration: none;"><tt></ins>/Library/MySQL/<ins style="color: red; font-weight: bold; text-decoration: none;"></tt> </ins>for all users of the Mac).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># Launch NeoOffice.</td><td> </td><td style="background: #eee; font-size: smaller;"># Launch NeoOffice.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"># From the '''NeoOffice''' menu, choose '''Preferences…'''.</td><td> </td><td style="background: #eee; font-size: smaller;"># From the '''NeoOffice''' menu, choose '''Preferences…'''.</td></tr>
</table>Sardissonhttps://neowiki.neooffice.org/index.php?title=Configuring_MySQL_using_JDBC_and_NeoOffice_2.x&diff=6548&oldid=prevSardisson: move 2.0 stuff to a page2006-08-27T04:36:00Z<p>move 2.0 stuff to a page</p>
<p><b>New page</b></p><div>{{handbook sidebar|DatabaseTOC}}<br />
<br />
While NeoOffice 2.0 and higher include the new “Base†database component, many people have existing MySQL databases they would like to use with NeoOffice to enter or manipulate data, including creating detailed forms and reports. This article contains information on installing, configuring, and using a MySQL database with NeoOffice 2.0 using a JDBC driver.<br />
<br />
==Installation Overview==<br />
* Download Connector/J 3.1 or later from the [http://www.mysql.com/products/connector/ MySQL website].<br />
** The included README gives much information.<br />
** The most important keypoints are:<br />
*** the class name of the JDBCdriver: <tt>com.mysql.jdbc.Driver</tt><br />
*** the URL format: <tt>jdbc:mysql://host.domain/database_name</tt><br />
<br />
*The jar file location:<br />
** for Neo: I had to put it in the <tt><NeoOffice>/Contents/MacOS/classes</tt> folder to get it found. Didn't check with recent release if the previous classpath setting does work.<br />
::: FYI. I just tried adding the MySQL jar file using the Security pane in the Tools->Options menu item Neo/J 1.1 Alpha 2. After adding the jar file in that pane and restarting Neo/J, I successfully connected to my MySQL database.<br />
::: This works with Neo/J 1.1 final and newer. The former option is probably better for providing it to all users, whereas this is well suited for <br />
: ''There is also an attachment (.sxw) to [http://www.openoffice.org/issues/show_bug.cgi?id=13753 OpenOffice.org Issue 13753] which contains screenshots and a different location for placing the Connector/J file.''<br />
<br />
==Detailed Installation and Usage for NeoOffice 2.0 Beta and above==<br />
===Installation===<br />
# If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).<br />
# Download Connector/J 3.1 from http://www.mysql.com and save it to the Desktop. (I downloaded v3.1.13, the tar.gz version).<br />
# Extract the Connector/J jar from the tar.gz archive.<br />
# Copy the .jar file to wherever you like (Perhaps ~/Library/MySQL/ for personal use, or /Library/MySQL/ for all users of the Mac).<br />
# Launch NeoOffice.<br />
# From the '''NeoOffice''' menu, choose '''Preferences…'''.<br />
# On the left is a tree of items. At the very top is "NeoOffice". Indented and underneath is a list of other items. Click on "Java".<br />
# This changes the panel on the right. At the right of this panel there are three buttons; click the bottom one marked "Class Path…".<br />
# This opens the "Class Path" window. Make sure that there are no other Connector/J versions installed (e.g., 3.0) or they will make life messy. To remove them, click the jar file to select, then click Remove. Repeat as necessary. (Note: not all items here are necessarily Connector/J archives, use some caution).<br />
# Click the "Add Archive…" button.<br />
# Browse to the directory where you installed the Connector/J 3.1 jar file (in step 4). Select the .jar file and click the "Open" button.<br />
# Click the "OK" button.<br />
# Exit NeoOffice.<br />
# Restart NeoOffice.<br />
<br />
You are now ready to use MySQL Databases with NeoOffice 2.0<br />
<br />
===Usage===<br />
# From the '''File''' menu, select '''New''' and then '''Database''' from the hierarchical menu; this opens the Database Wizard.<br />
# In the right hand panel, select '''Connect to an existing databae''' and from the list below select "MySQL".<br />
# Click '''Next >>>'''.<br />
# Select '''Connect using JDBC (Java Database Connectivity)''' and click '''Next >>>''' again.<br />
# Enter the name of your MySQL database in the '''Name of database''' field (e.g. <tt>test</tt>).<br />
# In the Server URL field enter <tt>localhost</tt><br />
# The '''Port number''' should be left as the default <tt>3306</tt> unless you have modified your MySQL installation.<br />
# The '''MySQL JDBC driver class:''' should also be left as the default <tt>com.mysql.jdbc.Driver</tt>.<br />
# To check that the JDBC Driver is working click '''Test class'''; if all is well a dialogue should appear reporting that the driver was loaded correctly.<br />
# Click '''Next >>>'''.<br />
# Enter your MySQL User name in the field provided and select '''Password required''' if you have a password set for that user. N.B. If you do not select this option you will never be prompted for a password and all connections will fail if one was set.<br />
# To check you have entered all the details correctly so far click '''Test connection'''.<br />
# If you need to enter a password you will now be prompted to enter it, and optionally have it remembered until you quit NeoOffice.<br />
# If all is well a dialogue will tell you so. If not go back to the previous screen and check the database name before returning to this screen and checking your username and password.<br />
# If you don't want to register the database (so it doesn't appears in the ---) then select '''No, do not register the database'''<br />
# Click '''Finish''' and choose a name and location to save the database.<br />
<br />
You are now read to create queries and forms that use your MySQL database.<br />
<br />
<br />
[[Category:NeoOffice]][[Category:Tips and Hints]]</div>Sardisson