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

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

mysql12

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

mysql11
Now we are connected to mysql database

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

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

use-test
Now you can perform any operation on database

Leave a Reply

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