dbForge Studio for MySQL tutorials and other MySQL resources

Develop, administer, and manage MySQL and MariaDB databases using the dbForge Studio for MySQL tool easily and effortlessly. Refine your skills and master the tool with the helpful resources introduced on the page!

Demo Videos

Introductory tutorial

Get started with the introductory video that describes key features of the dbForge Studio for MySQL tool.

MySQL Security Manager

Learn how to manage MySQL user accounts and grant user privileges in Security Manager.

Developing MySQL Databases with Database Projects

Learn how to develop a MySQL database with Database Project and Schema Compare.

Creating a Simple Connection

Learn how to establish a new connection, select a proper encoding, and verify this connection.

Creating an HTTP Connection

Learn how to upload a PHP file to a host, establish the HTTP connection and verify this connection.

Creating a New MySQL User

Learn how to create a new user and manage user privileges with the Security Manager functionality.

Creating a MySQL Foreign key

Learn how to create a foreign key between two MySQL tables in visual editor.

Creating a MySQL table

Learn how to create a MySQL table and add columns to the new table using dbForge Studio for MySQL.

Creating a MySQL database

Learn how to create a MySQL database and verify the database using dbForge Studio for MySQL.

Optimizing MySQL Queries

Learn how to optimize MySQL queries and boost database performance with Query Profiler.

Debugging MySQL Procedures

Learn how to debug MySQL stored procedures using MySQL debugger available in dbForge Studio for MySQL.

Comparing and synchronizing Schemas

Learn how to compare and synchronize MySQL and MariaDB schemas using a Schema Comparison tool or the command line.

Comparing and Synchronizing Data

Learn how to compare data in MySQL and MariaDB databases and synchronize data changes using dbForge Studio for MySQL.

Backing Up MySQL Database

Learn how to back up and restore databases using a MySQL Data Dump tool available in dbForge Studio for MySQL.

Exporting and Importing Data

Learn how to import and export data using the Data Export and Import tools built into dbForge Studio for MySQL.

Designing MySQL Charts

Learn how to create a pivot table for a query, design a chart in the pivot table, and adjust chart settings.

Creating SSH Connection

Learn how to access a remote MySQL server over SSH tunnel using dbForge Studio for MySQL.

Reverse Engineering of MySQL Objects

Learn how to reverse engineer MySQL Database objects with dbForge Studio for MySQL.

Migrating MySQL databases

Learn how to transfer databases between MySQL, MariaDB, Amazon Aurora, and Amazon RDS.

Using Session Manager

Learn how to manage queries and processes using MySQL Session Manager of dbForge Studio for MySQL.

MySQL Table Maintenance

Learn how to perform MySQL maintenance tasks with the help of dbForge Studio for MySQL.

Feature Highlights

How-to Articles

How to Create Tables using MySQL CREATE TABLE Statement and via GUI Tool for MySQL
MySQL primary key: CREATE and ALTER TABLE statements
How to write complex MySQL queries
How to Kill Certain Connections to a MySQL Database
Apply Integrity Constraint to Your MySQL Database
Backing Up All MySQL Server Databases or Only the Required Ones
Working with dbForge Studio on MacOS with help of Parallels Desktop
Importing Data by Mask
Using HTTP Tunneling
How to Transfer MySQL Databases
Connecting to Amazon RDS MySQL Database

To get started quickly, take a look at these guides:

Connecting to a Database

Set up a database connection to a MySQL server and configure its properties through the Database Connection Properties dialog box.

Creating and Editing a Query

After you have set up a database connection, you can easily create and run a query using dbForge Studio for MySQL.

Creating a Table in Table Editor

After you have connected a database to a MySQL server, you can create a table in Table Editor with a few clicks.

Data Export Overview

Export data from tables or views of your MySQL database to the most popular file formats such as Text, MS Excel, XML, CSV, DBF, etc.

dbForge Studio for MySQL

The most intelligent MySQL management tool