01.Installing and configuring Mysql

Installing mysql is pretty much simple

for installing in ubuntu use:

sudo apt-get install mysql-server

When installation about to complete mysql ask's for to set root user password,then set it and finish the installation.

First enter in to your root account by command in your terminal

mysql -u root -p, then enter password.In the root terminal type this command to create new user.
CREATE USER 'user_name'@'your_host' IDENTIFIED BY 'your_password';
example:CREATE USER 'jerin'@'localhost' IDENTIFIED BY 'password'; 
Next is to grant all privileges to use available commands in Mysql

GRANT ALL PRIVILEGES ON * . * TO 'user_name'@'your_host';
example: GRANT ALL PRIVILEGES ON * . * TO 'jerin'@'localhost'; 
Atlast reload the mysql setting by using 


No comments:

Post a Comment


selenium javascript alert box

This is a easy task to capture javascript based alertbox , /* * To change this license header, choose License Headers in Project Properti...