Connecting to Database

If you already have a database on your MySQL server, and you want to start working with it, you should create a profile for this database and establish the database connection.

You can do it in several ways.

The Quick Connection page of the Task Pane at the right side allows you to connect to the MySQL server quickly and select the database for creating the profile.

Use the New Connection group to specify the host name (or the IP-address) and the port number of your MySQL server. Then click the connect button - .

The login prompt dialog appears, which looks in the following way:

You should specify your MySQL user name and password to connect to the host. Click OK when done.

If everything is correct, the Quick Connections group changes its appearance, displaying all databases, available on the specified server. Click on any of the databases to create a profile for the appropriate database and establish connection automatically.

The Profile Window opens, allowing you to work with the database tables as well as create profile queries, forms, and perform other operations.

The another way to connect to an existing database is to click the Create a new profile... item at the Getting Started pane (or the File | New... menu item) and fill the connection properties within the Profile Properties Editor.

Set the host name or the IP-address of your MySQL server, select its port, specify your user name and password.

Select the database for connection from the Database list. Click Test Connect to check the connection, and click OK to create the profile.

After you have created a profile by one of the above means, you can save it to a disk as a file to use it for working with the specified database later. Select the File | Save menu item to save the database profile.