1
00:00:00,360 --> 00:00:06,660
Now we are going to create one database and one user for managing that database, so we're creating

2
00:00:06,660 --> 00:00:12,090
that database the command is create database employee; that mean we are just assuming that you have got a little

3
00:00:12,090 --> 00:00:18,720
bit knowledge of mysql and a little bit knowledge of php, even if you do not have the knowledge, then run these

4
00:00:18,720 --> 00:00:26,400
simple commands of mysql and then create one small code that we are going to create in next videos

5
00:00:26,640 --> 00:00:30,030
small application code to test that Lamp stack.

6
00:00:30,450 --> 00:00:34,580
Because in this case, our main concern is regarding Apache Web server.

7
00:00:34,590 --> 00:00:39,480
But we just wanted to show the connectivity of the whole Lamp stack.

8
00:00:39,490 --> 00:00:40,480
We wanted to show.

9
00:00:41,070 --> 00:00:44,550
So we are going to create the database, "create database employee;".

10
00:00:45,120 --> 00:00:47,020
Then we need to create one user.

11
00:00:47,280 --> 00:00:52,710
So what we are going to do, we are going to run this command "grant all on employee.* that mean

12
00:00:52,980 --> 00:00:58,280
we want to give the full control on the employee database to aanya

13
00:00:58,290 --> 00:01:06,330
@localhost that when we are going to create one aanya user that they can access that employee

14
00:01:06,330 --> 00:01:12,900
database on the localhost system only, identified by this is we are going to give the password.

15
00:01:13,440 --> 00:01:15,480
Asdf#1234.

16
00:01:16,620 --> 00:01:24,360
Then we have to after creating the user, we have to, "flush privilages" command so that this,

17
00:01:24,360 --> 00:01:28,320
user and changes get effective.

18
00:01:28,680 --> 00:01:36,030
Then we are going to look at show databases command and it is going to show us our new database that we have created,

19
00:01:36,030 --> 00:01:37,050
employee database.

20
00:01:37,350 --> 00:01:39,050
Then we are going to quit.

21
00:01:39,360 --> 00:01:42,180
So let us go to our master system.

22
00:01:42,540 --> 00:01:46,590
already we are logged in as a mysql.

23
00:01:46,590 --> 00:01:48,630
We have connected with the mariadb server.

24
00:01:48,960 --> 00:01:58,020
So what we are going to do, we are going to run this command create database.

25
00:01:59,340 --> 00:02:01,560
Our database name is employee.

26
00:02:04,210 --> 00:02:11,910
We are going to create this, then this is important command grant all on.

27
00:02:13,350 --> 00:02:19,800
Which database employee.*

28
00:02:21,330 --> 00:02:37,020
Then to which user we are giving it to aanya users @localhost, then identified by

29
00:02:38,460 --> 00:02:41,590
which user sorry, which password we have to give.

30
00:02:42,270 --> 00:02:45,090
We are specifying the password as Asdf#1234

31
00:02:45,630 --> 00:02:50,730
In your case, you can give any password that you want.

32
00:02:52,320 --> 00:02:59,820
Then we are going to flush the command is privileges.

33
00:03:03,310 --> 00:03:05,510
So we are going to run this command.

34
00:03:09,460 --> 00:03:16,690
So let us check the spelling privileges.

35
00:03:17,950 --> 00:03:26,380
So spelling mistakes were there, so please remember that now it is OK, then we are going to quit this

36
00:03:26,380 --> 00:03:35,080
database now we would like to log in aanya user, that user that we have created

37
00:03:35,680 --> 00:03:43,030
so that mean we were able to successfully create database and user for managing the database.