MySQL Test

Description

The MySQL Test can be used to check MySQL Server connectivity.

Parameters

Attribute

Description

Default

Required

id

Test ID / Name

Null

No

username

MySQL Server Username

Null

Yes

password

MySQL Server Password

Null

Yes

hostname

MySQL Server IP/Hostname

localhost

Yes

port

Port that MySQL Server is listening on

3306

No

database

MySQL database to run test against

mysql

No

Parameters specified as nested elements

Element

Description

Required

Statement

Statement to execute

No

Examples

Test MySQL connection to sakila database server

<MySQLTest name="Test Sakila MySQL Server" hostname="sakila.wave2.org" username="monitor" password="monitorpwd" />