How to connect to the MySQL database?

MYSQL allows to connect with the database server in mainly two ways.

?

1.Using command Line:

?

We can find the command-line client tool in the bin directory of the MySQL's installation folder. To invoke this program, we need to navigate the installation folder's bin directory and type the below command:

? mysql

?

Next, we run the below command to run the MYSQL server.

?shell>-mysql -u root -p

?

Finally enter the password for the selected user account root and press Enter.

Enter Password:******

?

After successful connect use the below command to use the database.

USE_database_name;

?

2.Using MYSQL Workbench

?

simply clicking the plus (+) icon or navigating to the menu bar -> Database -> Connect to Database, the following screen appears.?