Now we are going to create one database and one user for managing that database, so we're creating
that database the command is create database employee; that mean we are just assuming that you have got a little
bit knowledge of mysql and a little bit knowledge of php, even if you do not have the knowledge, then run these
simple commands of mysql and then create one small code that we are going to create in next videos
small application code to test that Lamp stack.
Because in this case, our main concern is regarding Apache Web server.
But we just wanted to show the connectivity of the whole Lamp stack.
We wanted to show.
So we are going to create the database, "create database employee;".
Then we need to create one user.
So what we are going to do, we are going to run this command "grant all on employee.* that mean
we want to give the full control on the employee database to aanya
@localhost that when we are going to create one aanya user that they can access that employee
database on the localhost system only, identified by this is we are going to give the password.
Asdf#1234.
Then we have to after creating the user, we have to, "flush privilages" command so that this,
user and changes get effective.
Then we are going to look at show databases command and it is going to show us our new database that we have created,
employee database.
Then we are going to quit.
So let us go to our master system.
already we are logged in as a mysql.
We have connected with the mariadb server.
So what we are going to do, we are going to run this command create database.
Our database name is employee.
We are going to create this, then this is important command grant all on.
Which database employee.*
Then to which user we are giving it to aanya users @localhost, then identified by
which user sorry, which password we have to give.
We are specifying the password as Asdf#1234
In your case, you can give any password that you want.
Then we are going to flush the command is privileges.
So we are going to run this command.
So let us check the spelling privileges.
So spelling mistakes were there, so please remember that now it is OK, then we are going to quit this
database now we would like to log in aanya user, that user that we have created
so that mean we were able to successfully create database and user for managing the database.