The MySQL tutorials are based on the World Database. This is a publically available database which is used for MySQL testing and demonstation. You can find out more about the World Database here
Before starting this tutorial, it is recommended you see the "Getting started with MySQL" section here.
It is assumed that the world database has been set up and and populated as follows
It is also assumed that an ODBC System DSN called "world_dsn" has been set up as follows
We use the user monty to connect to our datasource, but in
your instance the user might be different. In many cases, the root
user ID is used.
Or on Linux, assuming you are using the unixODBC driver, the following information in your odbc.ini
[world_dsn]
Description = The world database in mysql
Driver = DriverMysql
Trace = off
TraceFile = stderr
Server = localhost
Port = 3306
Database = world
UserName =
Password =
And this information in your odbcinst.ini
[DriverMysql]
Description = ODBC for MySQL
Driver = /usr/lib/unixODBC/libmyodbc3.so
Setup = /usr/lib/unixODBC/libodbcmyS.so
UsageCount = 1
For more information on setting up an ODBC System DSN, see this section
Finally, it assumed that the Web Service Discovery Wizard has been used to create 3 web services based on the 3 tables in the World database.
Legacy Perspective
Administration Perspective
Now select a tutorial
