Got it

The Series of MySQL -1- Basic of MySQL - EP 01_05

Latest reply: May 21, 2022 09:03:31 797 27 17 0 0

The Series of MySQL -1- Basic of MySQL - EP 01_05

 

HI Hi, Greetings!  i_f47.gif 

Happy December i_f25.gif


Hi Everyone,


 

Today, I would like to share with you an article about the first episode of Series of MySQL, and the content is given below.

 

a.    Deployment of MySQL

b.   Connection Types of MySQL

 

a.    Deployment of MySQL:


MySQL is one of the most extensively used relational database management systems in the industry today. It supports multi-user access and a variety of storage engines. Oracle Corporation is its backer. We will learn how to download and install MySQL for beginners in this section.


Prerequisites

The following requirements should be available in your system to work with MySQL:


MySQL Setup Software

o   Microsoft .NET Framework 4.5.2

o   Microsoft Visual C++ Redistributable for Visual Studio 2019

o   RAM 4 GB (6 GB recommended)


Download MySQL

Follow these steps:

Step 1: Go to the official website of MySQL and download the community server edition software. Here, you will see the option to choose the Operating System, such as Windows.


Step 2: Next, there are two options available to download the setup. Choose the version number for the MySQL community server, which you want. If you have good internet connectivity, then choose the mysql-installer-web-community. Otherwise, choose the other one.


1


Deployment MySQL on Windows


Step 1: After downloading the setup, unzip it anywhere and double-click the MSI installer .exe file. It will give the following screen:


222


Step 2: In the next wizard, choose the Setup Type. There are several types available, and you need to choose the appropriate option to install MySQL products and features. Here, we are going to select the Full option and click on the Next button.


3333


This option will install the following things: MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples, and many more.

Step 3: Once we click on the Next button, it may give information about some features that may fail to install on your system due to a lack of requirements. We can resolve them by clicking on the Execute button that will install all requirements automatically or can skip them. Now, click on the Next button.


444


Step 4: In the next wizard, we will see a dialog box that asks for our confirmation of a few products not getting installed. Here, we have to click on the Yes button.


555


After clicking on the Yes button, we will see the list of the products which are going to be installed. So, if we need all products, click on the Execute button.


6666


Step 5: Once we click on the Execute button, it will download and install all the products. After completing the installation, click on the Next button.


7777


Step 6: In the next wizard, we need to configure the MySQL Server and Router. Here, I am not going to configure the Router because there is no need to use it with MySQL. We are going to show you how to configure the server only. Now, click on the Next button.


8888


Step 7: As soon as you will click on the Next button, you can see the screen below. Here, we have to configure the MySQL Server. Now, choose the Standalone MySQL Server/Classic MySQL Replication option and click on Next. Here, you can also choose the InnoDB Cluster based on your needs.


999


Step 8: In the next screen, the system will ask you to choose the Config Type and other connectivity options. Here, we are going to select the Config Type as 'Development Machine' and Connectivity as TCP/IP, and Port Number is 3306, then click on Next.


10


Step 9: Now, select the Authentication Method and click on Next. Here, I am going to select the first option.


jkj


Step 10: The next screen will ask you to mention the MySQL Root Password. After filling the password details, click on the Next button.


1111


Step 11: The next screen will ask you to configure the Windows Service to start the server. Keep the default setup and click on the Next button.


q31


Step 12: In the next wizard, the system will ask you to apply the Server Configuration. If you agree with this configuration, click on the Execute button.


111111


Step 13: Once the configuration has been completed, you will get the screen below. Now, click on the Finish button to continue.


33333


Step 14: In the next screen, you can see that the Product Configuration is completed. Keep the default setting and click on the Next-> Finish button to complete the MySQL package installation.


xxxxxc


Step 15: In the next wizard, we can choose to configure the Router. So click on Next->Finish and then click the Next button.


177


Step 16: In the next wizard, we will see the Connect to Server option. Here, we have to mention the root password, which we had set in the previous steps.


188


In this screen, it is also required to check about the connection is successful or not by clicking on the Check button. If the connection is successful, click on the Execute button. Now, the configuration is complete, click on Next.

Step 17: In the next wizard, select the applied configurations and click on the Execute button.


19


Step 18: After completing the above step, we will get the following screen. Here, click on the Finish button.


44444


Step 19: Now, the MySQL installation is complete. Click on the Finish button.


5555555

Verify MySQL installation

Once MySQL has been successfully installed, the base tables have been initialized, and the server has been started, you can verify its working via some simple tests.

Open your MySQL Command Line Client; it should have appeared with a mysql> prompt. If you have set any password, write your password here. Now, you are connected to the MySQL server, and you can execute all the SQL command at mysql> prompt as follows:

For example: Check the already created databases with the show databases command:


2222

 

b.   Connection Types of MySQL:


A connection is a computer science feature that enables a user to communicate with database server software. The database server can be accessed by a user on the same workstation or from a remote location. As a result, we'll require connections to send commands to the database server and get responses in the form of a result set. We'll learn how to connect to MySQL Server in a variety of ways in this tutorial.

 

MySQL allows you to connect to the database server in a variety of ways. We can connect to the MySQL server using any of the client apps listed below after we've installed it:

·       Command-line client

·       MySQL Workbench

·       PHP Script. 


You are welcome to like and leave feedback in the comment area. 


Link: 


Main:



EP 01_01:

The Series of MySQL -1- Basic of MySQL - EP 01_01


EP 01_02:



EP 01_03:


EP 01_04:

The Series of MySQL -1- Basic of MySQL - EP 01_04



Source: 

·        https://www.w3schools.com/mySQl/default.asp

·        https://www.mysqltutorial.org/mysql-basics/


M M Zaheer Hussain

Stay Safe!

tt


The post is synchronized to: Author groupzaheernew's Author Collection

  • x
  • convention:

Vien
Created Dec 29, 2021 12:20:36

Good share
View more
  • x
  • convention:

EL.BODO
EL.BODO Created Feb 22, 2022 19:07:36 (0) (0)
✌  
Saqib123
Moderator Created Dec 29, 2021 16:50:21

Thanks for sharing
View more
  • x
  • convention:

EL.BODO
EL.BODO Created Feb 22, 2022 19:08:22 (0) (0)
✌  
zaheernew
MVE Author Created Dec 30, 2021 18:42:23

  • x
  • convention:

Rumana
Created Dec 31, 2021 06:02:31

The Series of MySQL -1- Basic of MySQL - EP 01_05-4572239-1
View more
  • x
  • convention:

huyvan
Created Dec 31, 2021 06:04:13

Well done
View more
  • x
  • convention:

faysalji
Moderator Author Created Jan 2, 2022 12:03:51

Thanks for sharing
View more
  • x
  • convention:

zaheernew
MVE Author Created Jan 9, 2022 06:18:38

@wissal @BAZ @Unicef @user_4147187 @E.DR_91 @umaryaqub @sachandio @Malik3000 @MahMush @Abdussamed @Vlada85 @cmarban @lucian2003 @sliawatimena @hamza1 @amr_rashedy @Diego.Silva @andersoncf1 @bruno.guedes @Kashif @Lucfabrice @AymanOT @tubaboraka @DrDoom @Mahedi @Aqeel73 @Saqib123 @DienLg @Anno7 @IndianKid @Rumana @Vesper_EvenStar @Irina @AL_93 @faysalji @jason_hu @Y_T_Z @Somemeow @hemin88 @Kevin_Thomas @harisaliehsan @Irshadhussain @azkasaqib @NTan33 @hanhcao @mytruc
View more
  • x
  • convention:

BWGARM
Created Jan 9, 2022 06:37:36

The Series of MySQL -1- Basic of MySQL - EP 01_05-4588511-1
View more
  • x
  • convention:

EL.BODO
EL.BODO Created Feb 24, 2022 20:40:29 (0) (0)
✌  
hamza11
Created Jan 9, 2022 19:46:07

Good share
View more
  • x
  • convention:

EL.BODO
EL.BODO Created Feb 23, 2022 19:11:16 (0) (0)
✌  
12
Back to list

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.