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]


Check our new tutorial how to create connection to MySQL Database with dbForge Studio. dbForge Studio for MySQL is a user-friendly and fast GUI Tool, that helps you to manage database without coding!

In this guide, we will show you how to create MySQL and Mariadb connections step by step. You don't need to learn a number of tutorials about workbench configuration! Just fill up database connection properties like in the video and save it with import and export wizard.

In this tutorial, we will also show you how to connect to other databases and remove all existed connections. Do you have any questions or suggestions? Feel free to write them in the comment section!

Timesteps:
0:00 Introduction
0:19 Getting started
0:34 Specifying General parameters in Database Connection Properties
01:11 Connecting to specific MySQL database
01:29 How to view connection properties
01:37 Creating a new database connection from menu
02:01 Show all databases option
02:12 Connection to localhost
02:28 View data in any table
02:35 Modify connection properties
02:45 Configuring Advanced tab in Database Connection Properties
03:08 What to do if data is displayed incorrectly
03:26 Configuring Security tab in Database Connection Properties
03:53 How to save you connections, using Import and Export wizard
04:11 How to delete connections
04:19 How to import saved connections
04:43 Get a bonus from Devart

👉 Check for detailed guide for getting started with dbForge Studio:
https://www.devart.com/dbforge/mysql/studio/getting-started.html

ℹ Don't know where to start? Watch our getting started video tutorial:
https://youtu.be/uSN4GxsjVHM

🔥 Download a 30-days trial version of dbForge Studio for MySQL:
https://www.devart.com/dbforge/mysql/studio/download.html

âś… Subscribe to our channel to get new tutorial about MySQL:
https://www.youtube.com/user/DevartSoftware/

#MySQL, #dbForge, #ConnecttoMySQL #database, #MySQLgui, #databases
Closed Caption:

Welcome to the dbForge Studio for MySQL tutorials. 
In this tutorial, we are going to show how to:
create MySQL and MariaDB connections
choose the right encoding
export and import the created connections
To get started with Studio, you need to
create a server connection. On the first run 
of the application without previously created
connections to MariaDB or MySQL local servers, 
the connections will be added automatically.
You just need to specify the connection parameters 
in the Database Connection Properties window.
Here, select the connection type 
from the list (TCP/IP is used most
commonly and is set as default, so 
you don’t need to change anything).
Then specify a database host: either an IP address 
or a domain name. You can leave the field empty.
In this case, the default connection to the 
local server will be localhost or 127.0.0.1.
Next, enter a user name and a password. From the 
drop-down list, choose the database you want to
connect to, and clear the Show all databases 
check box to view only the selected database.
After that, click Test Connection, and then click 
Connect. The connection to the selected database
will appear in Database Explorer.
To view the connection properties,
right-click the connection and select 
Properties on the shortcut menu.
Now, let’s create another database connection 
to the server. You can do it by clicking the
New Connection button on the toolbar or in 
Database Explorer. In the window that opens,
enter an IP address, a domain name or leave 
the field empty to connect to the localhost.
Then, enter a user name and a 
password, select a default database,
and press Enter. The connection is created. Now, 
let’s enable the Show all databases option.
When you first run dbForge Studio without 
the previously created connections,
but with the installed local database 
servers, connections to local servers will
automatically be added to Database Explorer.
To open the connections you’ve created,
enter the password. To view data in any table, 
select Retrieve Data on the shortcut menu.
To modify the connection properties, click Modify 
Connection on the shortcut menu and switch to the
Advanced tab in the Database Connection Properties 
window that will appear. Here you can configure
additional properties. Connection timeout means 
that you can specify the required period of time,
after which Studio stops trying to get the 
server's response to open the connection.
Execute timeout means that you can specify 
the required period of time after which
Studio stops trying to execute the query. Keep 
in mind that zero sets the infinite wait time.
If data is displayed incorrectly, 
set Unicode character encoding.
After that, verify the connection 
and refresh Database Explorer.
The data will be displayed correctly 
after you’ve changed the encoding.
On the other tabs, you can configure other 
parameters including SSH/SSL if necessary.
Also, you can save your connections using 
the Import and Export Settings wizard.
This can be convenient in certain 
situations and can save loads of time.
After successful export, delete all 
connections and import the ones you’ve saved.
As you can see, all the connections 
we have saved were created afresh.
Just download a 30-day free trial 
version of dbForge Studio for MySQL
and find out how easy and effortless it 
can be to create a database connection.

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

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 create a simple connection using dbForge Studio for MySQL?
How to create a simple connection using dbForge Studio for MySQL?

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

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

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.