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