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


installing perl dancer in ubuntu

For installing perl dancer you need curl utility for installing curl ,   sudo apt-get install curl Now we can install Perl-Dancer by thi...