Grant Privileges for Mysql Database

The Following is the command that can be executed for the issuing the privileges to the Users

GRANT ALL PRIVILEGES ON * . * TO 'user Name'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Note: user Name and Password Needs to be provided based on the Database credentials.

This query doesnot have any security threat,as long as the password is very well encrypted.