1
00:00:00,330 --> 00:00:06,520
Now we are going to connect to the database that we created by using that aanya user, so we have to now

2
00:00:06,540 --> 00:00:08,360
run the command mysql.

3
00:00:08,700 --> 00:00:10,170
-u mean user aanya

4
00:00:10,380 --> 00:00:16,110
-p that mean we have to specify the password then to which database we want to connect employee

5
00:00:16,110 --> 00:00:16,700
database.

6
00:00:17,460 --> 00:00:23,970
Then we will run the command use employee so that we are going to use that database.

7
00:00:24,270 --> 00:00:28,600
Then we are going to run one command show tables here.

8
00:00:28,950 --> 00:00:31,900
It is going to show us that no table is present.

9
00:00:32,400 --> 00:00:39,720
So what we are doing here, we are trying to connect to our employee database by using the aanya

10
00:00:39,720 --> 00:00:39,890
user.

11
00:00:40,410 --> 00:00:43,450
So let us go to our master system.

12
00:00:44,410 --> 00:00:55,260
Now, what we are going to do, we will type the command mysql -u user is aanya then we are

13
00:00:55,260 --> 00:01:00,340
going to specify the password Asdf#1234 whatever is our password.

14
00:01:00,450 --> 00:01:07,590
We are going to specify that then to which database we want to connect, employee is our database.

15
00:01:08,730 --> 00:01:13,980
We are going to specify then we are going to use which database.

16
00:01:14,100 --> 00:01:15,300
Employee database.

17
00:01:18,780 --> 00:01:28,920
So we are going to use that employe database, then we will run this command show tables so no table

18
00:01:28,920 --> 00:01:31,710
is present because we did not created any table.

19
00:01:32,190 --> 00:01:39,300
So in the next video, we are going to create the table so that we can store some data which our php application

20
00:01:39,300 --> 00:01:40,680
is going to fetch.