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

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.

Video Length: 02:54
Uploaded By: Devart
Published: 4/24/2014
View Count: 20,026

Related Software Products
dbForge Studio for MySQL
dbForge Studio for MySQL

Published By:
Devart

Description:
dbForge Studio for MySQL: A Full MySQL and MariaDB IDE With a Debugger, Compare Tools and Reports dbForge Studio for MySQL is Devart's Windows IDE for MySQL and MariaDB: a SQL editor with smart completion, a stored procedure debugger, a visual query builder and database designer, backup and restore, and, in the Professional edition, schema and data compare with sync scripts. Professional costs $179.95 a year (Standard $99.95, Enterprise $229.95...


Related Videos
How to create MySQL foreign key between two tables?
How to create MySQL foreign key between two tables?

Video Length: 01:34
Uploaded By: Devart (7/1/2013)
View Count: 96,329

MySQL and MariaDB client for Windows with GUI environment
MySQL and MariaDB client for Windows with GUI environment

Video Length: 04:17
Uploaded By: Devart (8/11/2014)
View Count: 25,437

How to Optimize MySQL Queries with Query Profiler by Devart?
How to Optimize MySQL Queries with Query Profiler by Devart?

Video Length: 02:58
Uploaded By: Devart (4/24/2014)
View Count: 18,197

How to debug MySQL procedures using dbForge Studio for MySQL?
How to debug MySQL procedures using dbForge Studio for MySQL?

Video Length: 02:54
Uploaded By: Devart (4/24/2014)
View Count: 16,438

How To: Export and Import Data with dbForge Studio for MySQL
How To: Export and Import Data with dbForge Studio for MySQL

Video Length: 02:58
Uploaded By: Devart (2/13/2015)
View Count: 15,187

Ultimate MySQL and MariaDB GUI Tool - #dbForge Studio for MySQL
Ultimate MySQL and MariaDB GUI Tool - #dbForge Studio for MySQL

Video Length: 06:28
Uploaded By: Devart (4/4/2018)
View Count: 13,669

What is the Best GUI tool for MySQL? Comprehensive overview of dbForge Studio for MySQL
What is the Best GUI tool for MySQL? Comprehensive overview of dbForge Studio for MySQL

Video Length: 05:51
Uploaded By: 0xSECRETenv (9/29/2022)
View Count: 6,992

How to connect to MySQL Database using dbForge Studio for MySQL [Easiest way]
How to connect to MySQL Database using dbForge Studio for MySQL [Easiest way]

Video Length: 04:58
Uploaded By: Devart (9/14/2021)
View Count: 6,606

The most offbeat promo video for software!
The most offbeat promo video for software!

Video Length: 01:13
Uploaded By: Devart (5/26/2011)
View Count: 4,729

The Ultimate Guide to Version Control in dbForge Studio for MySQL
The Ultimate Guide to Version Control in dbForge Studio for MySQL

Video Length: 02:43
Uploaded By: Devart (11/3/2023)
View Count: 790

Copyright © 2026, Ivertech. All rights reserved.