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

    Stellar Converter for Database Tool

    MySQL /

    Stellar Converter for Database

    Stellar MySQL Log Analyzer

    MySQL /

    Stellar Log Analyzer for MySQL

    Stellar Repair for MySQL

    MySQL /

    Stellar Repair for MySQL

    MySQL /

    How to secure your SQL Database: Tips and Tricks

    Stellar Converter for Database

    MySQL /

    Database Converter Tools

    ‹ phpMyAdmin Database Tool› MySQL CREATE DATABASE Statement

    Recent Posts

    • ChatGPT Plans Free and PlusChatGPT Subscription Plans
    • Stellar Converter for Database ToolStellar Converter for Database
    • Stellar MySQL Log AnalyzerStellar Log Analyzer for MySQL
    • Stellar Repair for MySQLStellar Repair for MySQL
    • ChatGPT IntroductionChatGPT Capabilities
    • How to secure your SQL Database: Tips and Tricks
    • ChatGPT4 Conversational AI FeaturesChatGPT4 Conversational AI Features
    • Trends in Software EngineeringShaping the Future of Development: Exploring Key Trends in Software Engineering
    • Java PerformanceImproving Java Performance with Multithreading
    • QDrant Vector DatabaseOpen-source Vector Databases
    • Difference between PHP and JavaScript?
    • Bing AI Browser Web ContentBing Conversation Styles
    • ChatGPT PreviewChatGPT Introduction
    • Open Source AI Frameworks TensorFlowOpen Source AI Frameworks
    • Artificial Intelligence Tools

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com