Steps to connect Mysql database via Mysql Workbench

kumkumsharma

Administrator
Staff member
Mysql workbench is an Mysql client tool which helps to connect Mysql database. You can easily connect with mysql database from your computer with this mysql client.

Here are the steps to use mysql client:
  • Install mysql workbench and then open it.
  • Click on “New Connection” and you will find this option in lower left.
  • Now “Setup a new connection” dialogue box will open and you have to enter below details:
  • Connection Name: Enter the name of connection
  • Connection Method: Standard (TCP/IP).
  • Hostname: Enter MySQL server IP address.
  • Port: 3306
  • Username: database username
  • Default Schema: Leave it.
  • Click on “Test connection”.
  • Enter your password and then check “Save password in vault”.
  • All your entered details are correct then you will get message “connection parameters are correct” and click on “Ok”.
  • Now you have to accept connection string by clicking on “Ok”.
  • You can see the entire newly created connection list under “SQL Development” section; you have to click on “Connection to connect”.
 
Top