There are three major parts to creating a user in MySQL.

1. IP address of the user will be connecting from.
2. User Privileges
3. User Name and Password
   
   
   

   Things not to provide for users because of security risks.

• Grant users with super privlieges

  EX.

  GRANT SUPER ON database.* TO opsourceadmin@'10.103.240.173' IDENTIFIED BY 'opsource';

• Grant users for login to MySQL using mutiple IP's

  EX.

  GRANT SELECT ON database.* TO opsourceadmin@'%' IDENTIFIED BY 'opsource';

• Root users always has to be localhost.

  EX.

  GRANT SUPER ON database.* TO root@'localhost' IDENTIFIED BY 'opsource';

  
  
  
  

  The command to create a user is following

GRANT <Privilege> ON database.<Databases_Name> TO <username>@<'IP_Address_user_is_using'> IDENTIFIED BY <'Password'>;

EX.

GRANT SELECT, INSERT, DELETE ON database.* TO opsourceadmin@'10.103.240.173' IDENTIFIED BY 'opsource';

The command to see user's permissions

select * from mysql.user where User=<'username'>;

EX.

select * from mysql.user where User='opsourceadmin';

REVOKE <privileges> PRIVILEGES ON database.<Databases_Name> FROM <username>@<'IP_Address_user_is_using'>;

EX.

REVOKE DELETE PRIVILEGES ON database.* FROM opsourceadmin@10.103.240.173;