Code2night
  • Home
  • Blogs
  • Tutorial
  • Post Blog
  • Tools
    • Json Beautifier
    • Html Beautifier
  • Members
    • Register
    • Login
  1. Home
  2. Blogpost
04 Jan
2023

How to Connect to a Database with MySQL Workbench

by Shubham Batra

422

Hello, everyone, and welcome to Code2Night! In this article, we will delve into the topic of how to connect to database using MySQL Workbench. As developers, working with databases is an essential skill, and MySQL is a powerful tool that allows us to interact with MySQL databases seamlessly. Whether you're a beginner or an experienced coder, understanding how to establish a connection between your code and a database is crucial for building robust and dynamic applications.


Step 1. Open MySQL.

Step 2. Click on the + sign to set up a new connection

Connect to Database

Step 3. In the “Set up a New Connection Dialogue” box, Type your Database connection credentials. The credentials will be like the following:

  1. Connection Name: You can name this whatever you like.
  2. Connection Method: Standard (TCP/IP).
  3. Hostname: You can use your domain our your cPanel IP address.
  4. Port: 3306
  5. Username: Your cPanel username or the user you created for the database.
  6. Password: cPanel password or the password for the database user that was created.
  7. Default Schema: This can be left blank.

Click Test Connection.


Step 4. Type your password and click the “Save Password in Vault” check box. Click Ok.


Step 5.MySQL Workbench should say “Connection parameters are correct“. Click Ok.


Step 6. Click Ok again to accept the connection settings

Step 7. After clicking ok Then you see the Database connection below

To open the database you have to Double-click on the EmployeeDb 


  • |
  • How to Connect to a Database with MySQL Workbench

Comments

Follow Us On Social Media - Like Us On Facebook

Best Sellers

product 1

Hand Hug Bracelet For Women Men Cuff Bangle Adjustable Lover Couple Bracelets

Can be given as a gift to your family, relatives, or friends

Buy $15.99
product 1

Teddy bear hug bear plush toy bear cub

Can be given as a gift to your family, relatives, or friends


Buy $49.99

Tags

LinkedinLogin
LinkedinProfile
GetLinkedinProfile
C#
Aspnet
MVC
Linkedin
ITextSharp
Export to Pdf
AspNet Core
AspNet
View to Pdf in Aspnet
Model Validation In ASPNET Core MVC 60
Model Validation
Model Validation In ASPNET Core MVC
Model Validation In ASPNET
Image Compression in AspNet
Compress Image in c#
AspNet MVC
Thank you for Downloading....!

Subscribe for more tutorials

Support our team

Continue with Downloading

Welcome To Code2night, A common place for sharing your programming knowledge,Blogs and Videos

  • Panipat
  • info@Code2night.com

Links

  • Home
  • Blogs
  • Tutorial
  • Post Blog

Popular Tags

Copyright © 2023 by Code2night. All Rights Reserved

  • Home
  • Blog
  • Login
  • SignUp
  • Contact
  • Terms & Conditions
  • Refund Policy
  • About Us
  • Privacy Policy
  • Json Beautifier