How to Install mysql server 5.6 on Ubuntu 14.04 LTS

1)
 Install MYSQL server 5.6.

Install MySql Server 5.6 using "apt-get" command.

anusree@anusree-VirtualBox:~$ sudo apt-get update
anusree@anusree-VirtualBox:~$ sudo apt-get install mysql-server-5.6

at the time of mysql installation you have to set password for the mysql roor user screen shot given bellow:

It will again ask mysql root password for confirmation screen shot given bellow:

2)
Login into MYSQL server.

After mysql server installation get finishes , it start the mysql service automatically. Hence, you can login now in MySQL Server with user root.
Login into MYSQL using:

    anusree@anusree-VirtualBox:~$ mysql -u root -p

3)
To Start MYSQL service:

    anusree@anusree-VirtualBox:~$ sudo service mysql start

4)
To Stop MYSQL service:

    anusree@anusree-VirtualBox:~$ sudo service mysql stop

 5)
 To Restart MYSQL service:

    anusree@anusree-VirtualBox:~$ sudo service mysql restart

 
 6)
Status of MYSQL after start:

    anusree@anusree-VirtualBox:~$ sudo service mysql status

 7)
 Status of MYSQL after stop:

     anusree@anusree-VirtualBox:~$ sudo service mysql status

8)
If you want to add new user, the command is given bellow:

    mysql> CREATE USER 'test'@'localhost' IDENTIFIED BY 'test123';
  
    Here, test ---> user name and, test123 is password for user "test".

9)
View the full list of mysql users, the command is given bellow:

   mysql> SELECT User,Host FROM mysql.user;

10)
How to delete a user in mysql the command is given bellow:

   mysql> DROP USER 'test'@'localhost';

and after deleting the user view the full list of mysql users

11)
How to grand different user permission:

•  ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no database is selected, across the system)

•   CREATE- allows them to create new tables or databases

•   DROP     -    allows them to them to delete tables or databases

•   DELETE -    allows them to delete rows from tables

•   INSERT -    allows them to insert rows into tables

•   SELECT -    allows them to use the Select command to read through databases

•   UPDATE -   allow them to update table rows

•   GRANT OPTION- allows them to grant or remove other users' privileges

The command for grand permission to the user is :

GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;



Suppose we have two user named "test" and "sample", and i am going to give SELECT permission to the user "test" and INSERT permission to the user "sample".

1)
Here we have two user "test" and "sample".

2)
Next i am going to give SELECT permission to the user "test".

3)
Next i am going to give INSERT permission to the user "sample".

Now the user "test" has only SELECT permission and the user "sample" have only INSERT permssion.

4)
Now i am going to check the permission of the user test. For that first i have to login as user "test".

The above picture shows that the user "test" have only SELECT permission.
When the user "test" try to insert a data to the table student it will cause error


5)
Now i am going to check the permission of the user sample. For that first i have to login as user "sample".

The above picture shows that the user "sample" have only INSERT permission.
When the user "sample" try to select a data to the table student it will cause error also try to delete a data from the table stdent will causes error.