Hi Abhijit,
There are many different ways to establish users and privileges in MYSQL. Client and GRANT command assure you about a safe connection. The syntax for establishing new users and privileges is as follows
GRANT privileges ON database.* TO
'username'@'hostname' This can be identified by the password. Privileges can be assigned one by one or by specifying all.
Mar 18, 2010