MySQL user account and database creation using command line

           
  Pranaam to all bhai ji _/\_
Today we will learn , how to create user account with database in MySQL server
                               
 ##################################################################
 #                                                                                                                              
 #                 Mysql database and user account creation using commands                          
 ##################################################################                                                                                                    


////////////////
//  step 1.
////////////////

login to mysql server using root account
command is
         mysql -u root -p
enter password for root account

/////////////////
//  Step 2
/////////////////

create database with name which you wants
command is
create database  database_name;
here database_name is the name of the database with which you want to create database
replace database_name with your database name
in my case , database name is indishell so command will be
create database indishell;

//////////////
// Step 3
//////////////

in this step we will define the user name and its password which will be owner of the database which we have created
command is

grant all on database_name.* to username_of_user@localhost IDENTIFIED BY 'user_password';

here
    database_name is the name of the database which we have created
    username_of_user is the name of the new user which will be owner for the database
    user_password is the password for the new user account

in my case,
database name is indishell
username is adstuck
password for user account is ica1046

once we have done with this command , our user account adstuck whose password is ica1046 will be created in mysql server and user will have full privileges on database indishell

enjoy >:D<

Thank you

-==[[Love to]]==--

zero Cool ,code breaker ica, root_devil, google_warrior,INX_r0ot,Darkwolf indishell,Baba ,Silent poison India,Magnum sniper,Atul  Dwivedi,ethicalnoob Indishell,Local root indishell,Irfninja indishell,Reborn India,L0rd Crus4d3r,AR AR,Mannu, ViKi, Hardeep singh Bhuppi,Mohit, Ffe, Anju, RR Mam, Acchi bacchi and DON