HTML TO JAVA

  To Find list of users and permission granted them in MYSQL run following command :          select user,host from MySQL.user; Here (i) host component tells on which host they are connecting from.          (ii)%  is a wild card character interprets as 'any ' host. To find the privilege(s) granted to a particular MySQL account: --> show grants for 'super'@'%';  Here super is user name and host name user concatenated by @ .

MYSQL 'GRANT' statement allows you to grant access privileges to database account. To achieve same ,syntax  is as follow: Syntax:- GRANT privileges [Column_List] ON  [Object_Type] Privilege_level To account [IDENTIFIED BY 'password'] [ REQUIRE encryption ] WITH with_option ; Detailed explanation: Privileges:- It indicates that you have assign privileges to account. column_List : - (1) Its  optional.                          (2) Column(s) to which privileges apply. Privileges_level :- Level at which privileges apply. You can use global  privileges,database privileges,table specific privileges, column privileges etc. Account :- Which  account is being granted privileges. Password: - Specifies password.It replace old password. Required:- Clause specify whether the account has to connect to database server over secure connec...

Crating New User in MYSQL: Syntax:  Create user <UserName@localhost> Idendified By  '<paswword>'; Eg.: Create user dbadmin@localhost Identified By 'dbadmin' ;