Mysql grant

Some mysql grant queries

Granting permission for a particular  DB only

mysql> grant all privileges on databasename.* to 'username'@'localhost';

mysql> flush privileges; 

Granting Permission for all the DB

mysql> grant all privileges on *.* to 'username'@'localhost'; 

Granting Permission from a particular IP

# grant all privileges on *.* to 'username'@'192.168.0.20'; 

 # grant usage on *.* to bob@localhost identified by 'passwd'; 

# SHOW GRANTS FOR 'admin'@'localhost';

Granting selected privilages for user

# grant select,insert,update,delete,create,drop on TestDb.* to 'ctechz'@'localhost' identified by 'ctechz';

 After creating the user give permission to him using grant

# create user username identified by 'password';

# GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;

 -- % means from all host.