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
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
