Connecting to a Database

dbForge Data Generator for MySQL offers you visual, quick, and simple way to manage database connections through the Connection Manager window.

Create a New Server Connection

Before you can connect to a database, you must create a server connection.

To create a server connection, perform the following actions:

  1. Open the Database Connection Properties dialog box by either clicking New Connection on the Database menu or by clicking the New Connection button on the Connection toolbar.

    New Connection

  2. Select the connection type in the Type box. There are tow connection types available: TC/IP and Named pipe.

  3. Enter the host name in the Host box.

  4. For a TC/IP connection, enter the port information in the Port box. Default port number is 3306. For a Named pipe connection, enter the pipe name in the Pipe box.

  5. Enter the login credentials in the User and Password fields.

  6. In Database, type or select the name of the database to which you want to connect.

  7. The Connection Name should be generated automatically from the Host name. You can create a distinctive name for your new connection.

  8. (optional) You can assign a category for a new connection in the Document Category box.

  9. (optional) You can click Advanced to configure advanced connection properties.

  10. (optional) You can click Security to configure security properties. For example, you can set up either SSL or SSH security properties.

  11. (optional) You can click HTTP to configure HTTP tunnel properties.

  12. (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.

  13. Click OK to create the connection.

The Connection toolbar is hidden by default. To unhide it, right-click the Menu bar and choose Connection.