TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

MySQL

Different MySQL Components

Overview

In this tutorial, we will learn different MySQL Components. Some of the MySQL database components are as follows:

  • MySQL Server
  • MySQL Workbench
  • MySQL Monitor
  • MySQL Shell
  • MySQL Router
  • MySQL JDBC Drivers

MySQL Server

MySQL Database Server is the core product. MySQL server is a relational database management system (RDBMS). We can create and manage database objects, store and retrieve data and is a back-end for application programs.

MySQL Workbench

MySQL Workbench is the GUI tool to manage the MySQL server instance. It allows us to create and design database schemas and work with the database objects like tables, views, etc.

  • Check Server Status.
  • Design and run SQL queries using the tool.
  • Start and Shutdown MySQL database instances.

MySQL Workbench UI Win11

MySQL Shell

MySQL client application to manage MySQL servers and InnoDB clusters.

 

MySQL Shell Windows 11

MySQL Monitor

MySQL Monitor is the program that we can start from command line prompt to interact with the MySQL database. We can start the monitor by connecting as the root user.

For example, to start MySQL monitor:

C:\TestingDocs>mysql -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.27 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current
 input statement.

 

MySQL Monitor

MySQL Router

MySQL High availability(HA) daemon for InnoDB cluster setup.

MySQL Connectors

MySQL Connectors provide database connectivity to various programming language application programs. Some of them are C/C++, Java, .NET, ODBC, etc,

JDBC Driver

JDBC ( Java DataBase Connectivity) Driver for database interaction with application programs.

 

—

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

https://www.mysql.com/

Related Posts

MySQL Workbench Windows 11

MySQL /

New MySQL Connection in Workbench

MySQL Command-line Client

MySQL /

Command-Line MySQL Client

Start MySQL Client

MySQL /

Start MySQL Client on Windows 11

Windows 11 Services Run Prompt

MySQL /

Start MySQL Server on Windows 11

MySQL Download Windows 11

MySQL /

Download & Install MySQL on Windows 11

‹ MySQL Workbench Overview› MySQL CREATE DATABASE Statement

Recent Posts

  • Flowchart Control structures
  • Draw a Square using Turtle Graphics
  • Flowgorithm File Errors
  • Write to Text File using Flowgorithm
  • Read Text File using Flowgorithm
  • Flowgorithm Turtle Graphics Flowchart
  • Update Flowgorithm to Latest Version
  • Flowgorithm File Symbols
  • Flowgorithm Turtle Graphics
  • Flowgorithm 3 New Features

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version