Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

Native Connection to MySQL repository

In most installations users will be able to create native connections to MySQL database without the need to install or configure any other software.

Prerequisites

  • A MySQL database server
  • An Enterprise Architect repository defined in the MySQL database server
  • You know the database user credentials that have SELECT, INSERT, UPDATE, DELETE, EXECUTE and SHOW VIEW access permissions to the Enterprise Architect repository

Access

Keyboard Shortcuts

Ctrl+O : Connect to Server

Other

Start Page | Server Connection (direct to 'Open Server Connection' dialog)

Project list | Open Project : Connect to Server

Start Page : Manage Projects : Connect to Server

Connect to Repository

1

In Enterprise Architect, open the 'Open Server Connection' screen ('Project list | Open Project : Connect to Server' ribbon option).

2

Select the MySQL option

3

Fill in the details of the database, including Server Name, Port, Database Name, Database User and Password

4

Click the [Test] button.  A "Connection Successful" popup message should be displayed, including a summary of the server's version details.

If the connection is not successful, the message should include a hint or reason why it failed, the reason(s) listed will need to be corrected before continuing.

5

Once step 4 succeeds the OK button will be enabled, click [OK] to open the repository.

Notes

  • Connecting to DBMS based Repositories is available in the Corporate, Unified and Ultimate Editions of Enterprise Architect

Learn more