how to give GLOBAL PRIVILEGES in MySQL? I need limited Global permission like Select Execute and grant privileges  to one user.

how can i give, can any one help me.
To provide All privileges to an user from a specific server your Grant commands can be like the one below.

     GRANT ALL PRIVILEGES ON database_name TO 'user'@'hostname' IDENTIFIED BY PASSWORD &lt;password&gt;;
     FLUSH PRIVILEGES;


To provide select and execute grants to your user,

GRANT SELECT, EXECUTE ON database_name TO username@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES


Don't forget to FLUSH PRIVILEGES after executing the grants.