{"id":2261,"date":"2013-07-12T15:24:57","date_gmt":"2013-07-12T07:24:57","guid":{"rendered":"http:\/\/rmohan.com\/?p=2261"},"modified":"2013-07-12T15:25:09","modified_gmt":"2013-07-12T07:25:09","slug":"mysql-grant","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2261","title":{"rendered":"Mysql grant"},"content":{"rendered":"

 <\/p>\n

Some mysql grant queries<\/div>\n
<\/div>\n
<\/div>\n
Granting permission for a particular\u00a0 DB only<\/div>\n
mysql> grant all privileges on databasename.* to ‘username’@’localhost’;<\/div>\n
mysql> flush privileges;<\/div>\n

 <\/p>\n

Granting Permission for all the DB<\/b><\/div>\n
mysql> grant all privileges on *.* to ‘username’@’localhost’;<\/div>\n

 <\/p>\n

Granting Permission from a particular IP<\/b><\/div>\n
# grant all privileges on *.* to ‘username’@’192.168.0.20’;<\/div>\n

 <\/p>\n

\u00a0# grant usage on *.* to bob@localhost identified by ‘passwd’;<\/div>\n
# SHOW GRANTS FOR ‘admin’@’localhost’;<\/div>\n

Granting selected privilages for user\u00a0
\n<\/b><\/p>\n

# grant select,insert,update,delete,create,drop on TestDb.* to ‘ctechz’@’localhost’ identified by ‘ctechz’;<\/div>\n

 <\/p>\n

\u00a0After creating the user give permission to him using grant<\/div>\n
# create user username identified by ‘password’;<\/div>\n
# GRANT ALL PRIVILEGES ON *.* TO ‘monty’@’%’ WITH GRANT OPTION;<\/div>\n

— % means from all host.<\/p>\n","protected":false},"excerpt":{"rendered":"

 <\/p>\n

Some mysql grant queries Granting permission for a particular DB only mysql> grant all privileges on databasename.* to ‘username’@’localhost’; mysql> flush privileges; <\/p>\n

 <\/p>\n

Granting Permission for all the DB mysql> grant all privileges on *.* to ‘username’@’localhost’; <\/p>\n

 <\/p>\n

Granting Permission from a particular IP # grant all privileges on *.* to ‘username’@’192.168.0.20’; <\/p>\n

 <\/p>\n

# […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2261"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2261"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2261\/revisions"}],"predecessor-version":[{"id":2263,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2261\/revisions\/2263"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}