How to create a simple connection using dbForge Studio for MySQL?

Learn how to set-up, select proper encoding and verify the established connection using dbForge Studio for MySQL.
Learn more: http://www.devart.com/dbforge/mysql/studio/

---

Closed Caption:

Welcome to dbForge Studio for MySQL
Tutorials. In this tutorial we learn how to
- setup a MySQL and MariaDB connections,
- choose proper encoding
- export and import created connections.
To begin working with Studio, you need to
create a server connection.
At the first run of the application without the
previously created connections to MariaDB or
MySQL local servers,
the connection will be added automatically.
You just need to specify the connection
parameters in the Database Connection
Properties window,
that will open in Data Explorer.
Enter a password, select a database,
and clear the Show all Databases option
to view the selected database only.
Click Test Connection and then OK.
The created connection opens in Database
Explorer.
To view connection propertis, select Properties
on the shortcut menu.
Let's create one more connection to a remote
server without data.
This feature is available from both -
the Start Page, and Database Explorer.
Enter IP, domain name or leave the field empty
to connect to a local host.
Enter a username and a password.
Select a default database and click Enter.
The connection has been created.
Now, let's turn off the Show All Databases
option.
At the first run of the application without the
previously created connections to several
installed local servers,
the connections will be added to Database
Explorer automatically.
To open the created connections, just enter a
password.
To view data of any table, click Retrieve Data
from the shortcut menu.
Choose "Modify Connection" from the shortcut
menu.
Go to the Advanced page.
Connection timeout means that you can
specify the required time period,
after which Studio stops its attempt to get
response from the MySQL server to open a
connection.
Execution timeout means that you can specify
the required time period after which Studio stops
its attempt to execute a query.
Note: zero sets the wait time to infinite.
Set the character encoding to unicode if the
data is not displayed correctly.
Then Test Connection and refresh data.
The data is displayed correctly after character
encoding has been changed.
You can save your connections using the
Import and Export Settings Wizard.
Now, Delete all connections,
and Import the saved ones.
As you can see, all saved connections were
created.
You have been watching the dbForge Studio
for MySQL tutorial.
Thank you for your attention.