| 1 |
Download and
install the MySQL ODBC driver from http://www.mysql.com/downloads/api-myodbc.html |
| 2 |
Download and install OpenOffice.org from http://www.openoffice.org |
| 3 |
Once installed, load up a blank OpenOffice.org document.
I always use a text document but you can also use a spreadsheet
document or HTML document. |
| 4 |
To begin connecting, select "Data
Sources..."
from the "Tools" pull-down menu to pull up the
"Data Source Administration" window.
|
|
The "Tools" pull down menu with "Data
Sources..." highlighted
|
|
|
The "Data Source Administration" window
|
|
|
| 5 |
Click on the "New Data Source" button in the upper let
corner of the of the Data Source Administration window.
|
| 6 |
You'll want to give your new data source a name and then
change the "Database Type" to MySQL. Note that the tabs offered
will change with the data type.
|
| 7 |
Select the "MySQL" tab and enter in the remote
database information. To begin, click the "..." button
to the right of the "Data
Source URL" text field.
|
|
The "Data Source Administration"
window with the MySQL tab in the forefront
|
|
|
The "..." button highlighted
|
|
|
| 8 |
Clicking the "..." button will pull up the "Data Source"
window which is actually part of the MySQL ODBC driver configuration.
|
| 9 |
In the lower right hand corner of the "Data Source"
window, click on the "Organize" button to pull up the "ODBC
Data Source Administrator" screen.
|
|
The "ODBC Data Source Administrator" screen
|
|
|
| 10 |
Click the "Add..." button on the right hand side of the
window to add a new data source to the list. This will pull
up the "Create New Data Source" wizard.
|
|
The "Create New Data Source" wizard
screen
|
|
|
| 11 |
In the first step of the create new data source wizard,
scroll down to the bottom of the list of drivers to find
the MySQL ODBC driver. Select the driver and click "Finish"
|
|
The ""Create New Data Source" wizard
with the MySQL ODBC driver selected
|
|
|
The "Finish" button
(yes, I am getting a little carried away
here...)
|
|
|
| 12 |
After clicking the "Finish" button in step
12, the "MySQL
ODBC Driver DSN Configuration" window will be presented.
This is where all the important information is entered.
|
| 13 |
- You need to enter a descriptive name for your new connection
in the "Data Source Name" text field.
- In the "Host/Server Name (or IP) field" enter the host
name (i.e. myserver.com) or IP number of your server
(i.e. 123.45.678.90).
- The "Database Name" field is the name exactly as
it is named on the remote server. I learned the hard
way this is case sensitive.
- "User" is the remote database
user account with privileges to log into this database.
- "Password"
is the case sensitive password the user needs to access
the remote database.
- You probably don't have to worry about the port number
or "SQL command on connect"
|
| 14 |
Once you have entered all of the information, click on
the "Test Data Source" button to verify you entered the information
correctly and a connection can be made.
|
|
| The "Test Data Source" button |
|
|
| The successful connection pop-up window |
|
|
| 15 |
Once you have successfully made a connection you now need
to get back out to the original "Data Source Administration"
window. Click "OK" to exit the "MySQL ODBC Driver DSN Configuration"
window. This will return you to the "ODBC Data Source Administrator"
screen with the new data source added to the list. |
| 16 |
Nothing here to do except click "OK" to be returned
to the "Data Source" window. Select your data source and
click
"OK" to return to the "Data Source Administration" window.
Now you can run queries, add/delete records and more using
the "Tables," "Queries," and "Links" tabs. There's a nice
Access-like query builder or you can enter SQL statements
directly if you want.
|
| 17 |
That's all there is to it! |
)
)
)
)
)
)
)
)
)
)
){kind=small}
)