MySQL
• MySQL is a publicly accessible Relational Database Management System (RDBMS)
that uses Structured Query language (SQL) to interact with databases.
• MySQL stores data in the form of tables that can be modified using Structured
Query Language (SQL).
• Its adaptability with different computing systems like Windows, Linux, macOS,
and Ubuntu has made it an easy-going RDBMS software option.
• MySQL works on various operating systems and with most of the top languages,
that includes
• MySQL is very fast, reliable, scalable, and easy to use
• MySQL is compliant with the ANSI SQL standard
• MySQL was first released in 1995
• MySQL is developed, distributed, and supported by Oracle Corporation
• MySQL is named after co-founder Monty Widenius's daughter: My PHP, C and
more. 1
MySQL
Who Uses MySQL?
• Huge websites like Facebook, Twitter, Airbnb, [Link], Uber, GitHub,
YouTube, etc.
• Content Management Systems like WordPress, Drupal, Joomla!, Contao, etc.
• A very large number of web developers around the world
Show Data On Your Web Site
• To build a web site that shows data from a database, you will need:
• An RDBMS database program (like MySQL)
• A server-side scripting language, like PHP
• To use SQL to get the data you want
• To use HTML / CSS to style the page
2
What is MySQL Workbench ?
MySQL Workbench is a graphical tool for working with MySQL servers and
databases. MySQL Workbench fully supports MySQL server version 5.7 and
higher. Deprecated versions of MySQL Server (prior to version 5.7) are
incompatible with MySQL Workbench and should be upgraded before you
attempt to make a connection.
MySQL Workbench functionality covers five main topics:
• SQL Development: Enables you to create and manage connections to
database servers. Along with enabling you to configure connection
parameters, MySQL Workbench provides the capability to execute SQL queries
on the database connections using the built-in SQL Editor.
• Data Modeling (Design): Enables you to create models of your database
schema graphically, reverse and forward engineer between a schema and a
live database and edit all aspects of your database using the comprehensive
Table Editor. The Table Editor provides easy-to-use facilities for editing Tables,
Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges,
Routines and Views. 3
What is MySQL Workbench ?
• Server Administration: Enables you to administer MySQL server instances by
administering users, performing backup and recovery, inspecting audit data,
viewing database health, and monitoring the MySQL server performance.
• Data Migration: Allows you to migrate from Microsoft SQL Server, Microsoft
Access, Sybase ASE, SQLite, SQL Anywhere, PostgreSQL, and other RDBMS
tables, objects and data to MySQL. Migration also supports migrating from
earlier versions of MySQL to the latest releases.
• MySQL Enterprise Support: Support for Enterprise products such as MySQL
Enterprise Backup, MySQL Firewall, and MySQL Audit.
MySQL Workbench is available in two editions: the Community Edition and the
Commercial Edition.
• The Community Edition is available free of charge.
• The Commercial Edition provides additional Enterprise features, such as
access to MySQL Enterprise Backup, MySQL Firewall, and MySQL Audit.
4
MySQL Workbench Installation
• Download MySQL Installer for Windows from the following link and execute it.
[Link]
Select [Link] if you have good internet connection, 5
otherwise choose [Link].
MySQL Workbench Installation
• It will ask for permission; when it does, click Yes. The installer will then open.
Now, it will ask to choose the setup type. Here, select Custom.
6
MySQL Workbench Installation
• Click on Next. With this, you will install MySQL server, MySQL
Workbench, and MySQL shell.
• Open MySQL Servers, select the server you want to install, and move it
to the Products/Features to be installed window section. Now, expand
Applications, choose MySQL Workbench and MySQL shell. Move both of
them to ‘Products/Features to be installed’.
7
MySQL Workbench Installation
Click on the Next button. Now, click on the Execute button to download and
8
install the MySQL server, MySQL Workbench, and the MySQL shell.
MySQL Workbench Installation
Once the product is ready to configure, click on Next. Under Type and
Networking, go with the default settings and select Next. 9
MySQL Workbench Installation
• For authentication, use the recommended strong password encryption.
• Set your MySQL Root password and click on next. 10
MySQL Workbench Installation
Go for the default windows service settings and under apply configuration,
click on execute. Once the configuration is complete, click on Finish. 11
MySQL Workbench Installation
Complete the installation. This will now launch the MySQL Workbench and the
MySQL Shell. 12
MySQL Workbench Installation
Once MySQL Workbench is installed, select the Local instance and enter the
password. 13
MySQL Workbench Installation
Now, you can use the MySQL query tab to write your SQL queries.
14
MySQL Workbench
For more details, refer to the document "MySQL [Link]"
available in the folder named "References".
15