Create users in MySQL

Create users

The following steps are explained to you how create the users in MySQL.

1. This query is used to create a user in the particular host only,
    create user 'username'@'hostname' identified by 'password'; This user cannot access from the other hosts
   
2. If you want to the user access from other machines then use the below query,
   create user 'username'@'%';
3. The below query is used to give the all privileges to the user on the particular database,
   

   grant all privileges on '<database>.<tables>' to 'username'@'hostname';

4. The below query is used to give some privileges to users on the particular database,
   

   grant select,update on '<database>.<tables>' to 'username'@'hostname';