Connecting to a database

dbForge Studio 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 one of the following ways:

    • Click New Connection on the Database menu

    - or-

    • Click the New Connection button on the Connection toolbar.

    Database Connection Properties dialog box

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

  3. Enter the host name in the Host box.

  4. For a TCP/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.

Note

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

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?
Download a free 30-day trial