MySQL Database Connection

We already installed mysql Database
so you can access database through

1. Mysql command line client
2. Mysql Workbench

In order open mysql just type “mysql” in start menu

Now We will proceed with Mysql command line client.
just click on mysql 5.5 Command line client
you will see below window


Now we will use default user root.
provide password which you have created while installing my sql.

Now we are connected to mysql database

Query to see list of database name from mysql database
query: show databases

Now you can use any database using database query called
query: use databasename;

Now you can perform any operation on database

Leave a Reply

Your email address will not be published. Required fields are marked *