Got it

The Series of MySQL -2- MySQL Workbench - EP 02_02 Highlighted

Latest reply: May 21, 2022 09:02:01 812 33 21 0 0

The Series of MySQL -2- MySQL Workbench - EP 02_02

 

HI Hi, Greetings!  i_f47.gif 

Happy January i_f25.gif

 

Hi Everyone,

 

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


a. MySQL Workbench environment deployment

b. MySQL Workbench Editions

c. MySQL Workbench Administration Tool

d. MySQL Workbench Manager (Create, Alter, Drop Delete)

e. MySQL Workbench Database Export and Import 

 

MySQL Workbench environment deployment

We'll learn how to download and install MySQL Workbench in this article.


Prerequisites

To function with MySQL Workbench, your system must meet the following requirements:


o MySQL Server: You can download

o MySQL Workbench: You can download

o Microsoft .NET Framework 4.5.2

o Microsoft Visual C++ Redistributable for Visual Studio 2019

o RAM 4 GB (6 GB recommended)


Step 1: 

The MySQL Community Server must first be installed. Double-click the MySQL installer.exe file to start the installation. The following screen appears after double-clicking the.exe file:


111


Step 2: 

Select a Setup Type and then click Next. There are several types, and you must select the appropriate one to install MySQL's product and features. Because only MySQL Server and Workbench are required, we'll choose the Custom option. The Full option is available if you require more features.


ddd


Step 3: 

The following screen will appear when you click the Next button.


3


Click the plus (+) icon in the MySQL Server section of this screen. By clicking on the right arrow symbol, you can select MySQL Server and add it to the right side box.


444


Now go to the Application section and click the Next button, just like you did with MySQL Server. The next screen elucidates the situation in greater detail.


555

Step 4: 

The following screen will appear after you click Next. This screen verifies that MySQL Server and Workbench meet all of the prerequisites. All requirements will be installed automatically as soon as you click the Execute button. Then, press the Next key.


6666


Step 5: 

To download and install the MySQL Server and Workbench, go to this screen and click the Execute button.

777


Click the Next button once the download and installation are finished.


777


Step 6: 

On the next screen, click the Next button to configure the MySQL Server.


9999


Step 7: 

The screen below appears as soon as you click the Next button. The MySQL Server must now be configured. Click Next after selecting Standalone MySQL Server/Classic MySQL Replication.


10


Step 8: 

The system will prompt you to select the Config Type as well as other connectivity options on the next screen. Select 'Development Machine' as the Config Type, TCP/IP as the Connectivity, and Port Number as 3306 as the Port Number, then click Next.


111


Step 9: 

Finally, click Next after selecting the Authentication Method.


12


Step 10: 

Select an account, username, and password on the following screen. Click the Next button after you've completed all of the fields.


13


Step 11: 

You'll be prompted to configure the Windows Service on the following screen. Click Next and keep the default settings.


15


Step 12: 

The system will prompt you to apply Server Configuration on the next screen. Click the Execute button to finish this setup.


155


Step 13: 

After the configuration is finished, you should see the screen below. To proceed, click Finish.


16


Step 14: 

The Product Configuration is now complete, as you can see on the next screen. To complete the MySQL package installation, keep the default settings and click Next-> Finish.


17


17777


Step 15: 

After clicking the Finish button, the MySQL Workbench should open on your computer, as shown below.


19


Step 16: 

You must make a connection on the screen above. To do so, double-click the red arrow-designated box. You'll see a popup window asking you to enter the password you created earlier during the installation. You will be able to connect to the server after entering the password.


20


Step 17: 

Create a new connection if you don't already have one. The following screen appears when you click the plus (+) icon or go to the menu bar -> Database -> Connect to Database. Now you must complete all of the fields. You must ensure that the password you enter is the same as the one you created earlier.


222


Step 18:

When you've finished filling out all of the fields, click Test Connection to see if the database is connected. If the connection is successful, the following screen will appear. To complete the setup, click the OK->OK button.


233


Step 19: 

It will open the MySQL Workbench screen once you have completed all of the setups. Double-click the newly created connection to bring up the screen below, where you can run the SQL command.


222222

Source: 

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

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


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


Link: 



EP 02_01:

The Series of MySQL -2- MySQL Workbench - EP 02_01



EP 02_03:

The Series of MySQL -2- MySQL Workbench - EP 02_03



EP 02_04:

The Series of MySQL -2- MySQL Workbench - EP 02_04



M M Zaheer Hussain

Stay Safe!

tt

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

  • x
  • convention:

little_fish
Admin Created Jan 14, 2022 10:11:51

Thanks
View more
  • x
  • convention:

zaheernew
MVE Author Created Jan 14, 2022 15:29:32

  • x
  • convention:

Saqib123
Moderator Created Jan 14, 2022 18:18:02

Thanks for sharing
View more
  • x
  • convention:

zaheernew
zaheernew Created Jan 14, 2022 18:49:30 (0) (0)
Awesome  
Rumana
Created Jan 14, 2022 18:43:02

Very Interesting all parts are superb.
View more
  • x
  • convention:

BWGARM
Created Jan 15, 2022 01:33:01

The Series of MySQL -2- MySQL Workbench - EP 02_02-4602635-1
View more
  • x
  • convention:

faysalji
Moderator Author Created Jan 17, 2022 05:37:09

Thanks for sharing
View more
  • x
  • convention:

Hujian
Admin Created Jan 19, 2022 00:43:37

Thank you!
View more
  • x
  • convention:

Saqibaz
Created Jan 19, 2022 05:33:17

Thank you
View more
  • x
  • convention:

Lucfabrice
MVE Author Created Jan 19, 2022 05:42:50

Very useful !!!
View more
  • x
  • convention:

123
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.