{"id":7731,"date":"2015-03-28T07:58:14","date_gmt":"2015-03-28T11:58:14","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=7731"},"modified":"2015-03-30T21:41:12","modified_gmt":"2015-03-31T01:41:12","slug":"mysql-%e0%a6%8f%e0%a6%b0-%e0%a6%a1%e0%a6%be%e0%a6%9f%e0%a6%be%e0%a6%ac%e0%a7%87%e0%a6%9c-%e0%a6%95%e0%a7%87-%e0%a6%b8%e0%a7%81%e0%a6%b0%e0%a6%95%e0%a7%8d%e0%a6%b7%e0%a6%bf%e0%a6%a4-%e0%a6%95%e0%a6%b0","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=7731","title":{"rendered":"MySQL \u098f\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u0995\u09c7 \u09b8\u09c1\u09b0\u0995\u09cd\u09b7\u09bf\u09a4 \u0995\u09b0\u09be"},"content":{"rendered":"

MySQL \u098f\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u0995\u09c7 \u09b8\u09c1\u09b0\u0995\u09cd\u09b7\u09bf\u09a4 \u0995\u09b0\u09be
\n————————————————-
\nMySQL \u0987\u09a8\u09cd\u09b8\u099f\u09b2\u09c7\u09b6\u09a8\u09c7\u09b0 \u09aa\u09b0 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u099f\u09c7\u09b8\u09cd\u099f \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c, \u09b8\u0982\u09b6\u09cd\u09b2\u09bf\u09b7\u09cd\u099f \u0987\u0989\u099c\u09be\u09b0 \u098f\u09ac\u0982 \u09a4\u09be\u09a6\u09c7\u09b0 \u09aa\u09be\u09b0\u09ae\u09bf\u09b6\u09a8 \u0985\u09aa\u09b8\u09be\u09b0\u09a8 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u0964 \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf\u099f\u09bf \u09a8\u09bf\u099a\u09c7 \u09ac\u09cd\u09af\u0996\u09cd\u09af\u09be \u0995\u09b0\u09be \u09b9\u09b2\u0983<\/p>\n

— DROP DATABASE test;<\/p>\n

— SELECT db.Host, db.Db, db.User, db.Select_priv -> FROM db WHERE (db.DB =<\/p>\n

“vworksDB”);<\/p>\n

— SELECT db.User, db.Host, db.Db -> FROM db -> WHERE (db.Db LIKE ‘test%’);<\/p>\n

— DELETE FROM db<\/p>\n

-> WHERE (db.Db LIKE ‘test%’);<\/p>\n

—<\/p>\n

mysql> DELETE FROM db<\/p>\n

-> WHERE (db.Host = “%”);<\/p>\n

mysql> DELETE FROM db<\/p>\n

-> WHERE (db.User = “”);<\/p>\n

— SELECT user.Host, user.User<\/p>\n

-> FROM user<\/p>\n

-> WHERE ((user.Host = “%”) OR (user.User = “”));<\/p>\n

—<\/p>\n

DELETE FROM user -> WHERE ((user.Host = “%”) OR (user.User = “”)); —<\/p>\n

FLUSH PRIVILEGES; —<\/p>\n

Reference: http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=598<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL \u098f\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u0995\u09c7 \u09b8\u09c1\u09b0\u0995\u09cd\u09b7\u09bf\u09a4 \u0995\u09b0\u09be ————————————————- MySQL \u0987\u09a8\u09cd\u09b8\u099f\u09b2\u09c7\u09b6\u09a8\u09c7\u09b0 \u09aa\u09b0 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u099f\u09c7\u09b8\u09cd\u099f \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c, \u09b8\u0982\u09b6\u09cd\u09b2\u09bf\u09b7\u09cd\u099f \u0987\u0989\u099c\u09be\u09b0 \u098f\u09ac\u0982 \u09a4\u09be\u09a6\u09c7\u09b0 \u09aa\u09be\u09b0\u09ae\u09bf\u09b6\u09a8 \u0985\u09aa\u09b8\u09be\u09b0\u09a8 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u0964 \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf\u099f\u09bf \u09a8\u09bf\u099a\u09c7 \u09ac\u09cd\u09af\u0996\u09cd\u09af\u09be \u0995\u09b0\u09be \u09b9\u09b2\u0983 — DROP DATABASE test; — SELECT db.Host, db.Db, db.User, db.Select_priv -> FROM db WHERE (db.DB = “vworksDB”); — SELECT db.User, db.Host, db.Db -> FROM db -> WHERE (db.Db … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[257],"tags":[307],"class_list":["post-7731","post","type-post","status-publish","format-standard","hentry","category-----mysql","tag-mysql","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":9141,"url":"http:\/\/bangla.sitestree.com\/?p=9141","url_meta":{"origin":7731,"position":0},"title":"\u0985\u09cd\u09af\u09be\u09aa \u098f\u09ae\u098f\u09b2 \u098f \u0985\u09cd\u09af\u09be\u09ae\u09be\u099c\u09a8 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be (AppML using Amazon Database)","author":"Author-Check- Article-or-Video","date":"May 31, 2015","format":false,"excerpt":"\u09b9\u09cd\u09af\u09be\u09b2\u09cb \u09ac\u09a8\u09cd\u09a7\u09c1\u09b0\u09be, \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u09b8\u09be\u0987\u099f\u09c7 \u0986\u09b8\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09a7\u09a8\u09cd\u09af\u09ac\u09be\u09a6... \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09ae\u09b0\u09be \u0986\u09ae\u09be\u099c\u09a8 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09ae\u09cd\u09aa\u09b0\u09cd\u0995\u09c7 \u0986\u09b2\u09cb\u099a\u09a8\u09be \u0995\u09b0\u09ac\u0964 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f \u09b8\u0982\u09af\u09c1\u0995\u09cd\u09a4 \u09b9\u0993\u09df\u09be \u0996\u09c1\u09ac \u098f\u0995\u099f\u09be \u0995\u09a0\u09bf\u09a8 \u0995\u09be\u099c \u09a8\u09df\u0964 \u098f\u0995\u099f\u09c1 \u099c\u09be\u09a8\u09b2\u0987 \u09a4\u09cb\u09ae\u09b0\u09be \u09b8\u09b9\u099c\u09c7\u0987 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f\u09b0 \u09b8\u09be\u09a5\u09c7 \u09b8\u0982\u09af\u09c1\u0995\u09cd\u09a4 \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7 \u0986\u09b8 \u099c\u09c7\u09a8\u09c7 \u09a8\u09c7\u0987... \u0986\u09ae\u09be\u099c\u09a8 \u09b0\u09bf\u09b2\u09c7\u09b6\u09a8\u09be\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09b8\u09be\u09b0\u09cd\u09ad\u09bf\u09b8 \u0995\u09bf (RDS) \u09ac\u09bf\u09ad\u09bf\u09a8\u09cd\u09a8 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09aa\u09cd\u09b0\u09a4\u09bf\u09b7\u09cd\u09a0\u09be\u09a8\u09c7\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u0986\u09ae\u09be\u099c\u09a8 \u09b9\u09b2\u09cb \u098f\u0995\u099f\u09bf \u09aa\u09cd\u09b0\u09a4\u09bf\u09b7\u09cd\u09a0\u09be\u09a8\u0964\u2026","rel":"","context":"In "AppML : Application Modeling Language"","block_context":{"text":"AppML : Application Modeling Language","link":"http:\/\/bangla.sitestree.com\/?cat=796"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6140,"url":"http:\/\/bangla.sitestree.com\/?p=6140","url_meta":{"origin":7731,"position":1},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c (PHP MySQL Database)","author":"Author-Check- Article-or-Video","date":"February 6, 2015","format":false,"excerpt":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f\u09b0 \u09aa\u09b0\u09bf\u099a\u09bf\u09a4\u09bf Ali Hossain Student of English Literature, Jahangirnagar University. \u00a0 \u0986\u099c\u09be\u0995\u09c7 \u0986\u09ae\u09b0\u09be \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f\u09b0 \u09b8\u09ae\u09cd\u09aa\u09b0\u09cd\u0995\u09c7 \u099c\u09be\u09a8\u09ac\u0964 PHP (\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf) \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u0986\u09aa\u09a8\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u09c7\u09b0 \u09b8\u09be\u09a5\u09c7 \u09b8\u0982\u09af\u09cb\u0997 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7\u09a8 \u098f\u09ac\u0982 \u09a4\u09be \u09a8\u09bf\u09aa\u09c2\u09a8\u09ad\u09be\u09ac\u09c7 \u09aa\u09b0\u09bf\u099a\u09be\u09b2\u09a8\u09be \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7\u09a8\u0964 MySQL (\u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u09b2) \u09b9\u099a\u09cd\u099b\u09c7 \u09b8\u09ac\u099a\u09c7\u09df\u09c7 \u099c\u09a8\u09aa\u09cd\u09b0\u09bf\u09df \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae \u09af\u09c7\u099f\u09be \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u098f\u09b0 \u09b8\u09be\u09a5\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4\u2026","rel":"","context":"In "\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial"","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69093,"url":"http:\/\/bangla.sitestree.com\/?p=69093","url_meta":{"origin":7731,"position":2},"title":"Securing MySQL Database #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"After installing mysql, we will need to remove test database and associated users and their permissions. We will need to use mysql database to remove associated users and permission.--DROP DATABASE test; --SELECT db.Host, db.Db, db.User, db.Select_priv -> FROM db WHERE (db.DB = \"vworksDB\");---SELECT db.User, db.Host, db.Db -> FROM db ->\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7542,"url":"http:\/\/bangla.sitestree.com\/?p=7542","url_meta":{"origin":7731,"position":3},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf (PHP), \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 (MySQL), \u099c\u09be\u09ad\u09be (Java)","author":"Author-Check- Article-or-Video","date":"March 27, 2015","format":false,"excerpt":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u098f\u09b0 \u09aa\u09c1\u09b0\u09cb \u09ae\u09be\u09a8\u09c7 \u09b9\u09b2 \u09b9\u09be\u0987\u09aa\u09be\u09b0\u099f\u09c7\u0995\u09cd\u09b8\u099f \u09aa\u09cd\u09b0\u09bf\u09aa\u09cd\u09b0\u09b8\u09c7\u09b8\u09b0\u0964 \u0993\u09aa\u09c7\u09a8 \u09b8\u09cb\u09b0\u09cd\u09b8 \u09b8\u09ab\u099f\u0993\u09df\u09cd\u09af\u09be\u09b0 \u09b9\u0993\u09df\u09be\u09df \u098f\u099f\u09bf \u09ac\u09bf\u09a8\u09be\u09ae\u09c2\u09b2\u09cd\u09af \u09a1\u09be\u0989\u09a8\u09b2\u09cb\u09a1 \u0993 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df\u0964 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a4\u09c7 \u0995\u09be\u099c \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u098f\u0987\u099a\u099f\u09bf\u098f\u09ae\u098f\u09b2 \u098f\u09ac\u0982 \u099c\u09be\u09ad\u09be\u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f \u09b8\u09ae\u09cd\u09ac\u09a8\u09cd\u09a7\u09c7 \u09a7\u09be\u09b0\u09a8\u09be \u09a5\u09be\u0995\u09be \u09a6\u09b0\u0995\u09be\u09b0\u0964 \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b9\u09b2 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u0964 \u098f\u099f\u09bf \u09b8\u0995\u09b2 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b8\u09ae\u09b0\u09cd\u09a5\u09a8 \u0995\u09b0\u09c7\u0964 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u098f\u09b0 \u09ae\u09a4 \u098f\u099f\u09bf\u0993 \u09ac\u09bf\u09a8\u09be\u09ae\u09c2\u09b2\u09cd\u09af \u09a1\u09be\u0989\u09a8\u09b2\u09cb\u09a1 \u0993 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df\u0964\u2026","rel":"","context":"In "\u099c\u09be\u09ad\u09be"","block_context":{"text":"\u099c\u09be\u09ad\u09be","link":"http:\/\/bangla.sitestree.com\/?cat=266"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6085,"url":"http:\/\/bangla.sitestree.com\/?p=6085","url_meta":{"origin":7731,"position":4},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf : \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be (PHP Create a MySQL Database)","author":"Author-Check- Article-or-Video","date":"February 24, 2015","format":false,"excerpt":"Sheikh Mahfuzur Rahman \u00a0 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f\u0995 \u09ac\u09be \u09a4\u09be\u09b0\u0993 \u09ac\u09c7\u09b6\u09bf \u099f\u09c7\u09ac\u09b2 \u09a8\u09bf\u09df\u09c7 \u0997\u09a0\u09bf\u09a4\u0964 \u0995\u09cb\u09a8 MySQL \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u09ac\u09be \u09ae\u09c1\u0981\u099b\u09c7 \u09a6\u09bf\u09a4\u09c7 \u099a\u09be\u0987\u09b2\u09c7 \u0986\u09aa\u09a8\u09be\u09b0 \u09ac\u09bf\u09b6\u09c7\u09b7 \u09a7\u09b0\u09a3\u09c7\u09b0 \u0986\u0987\u09a8\u0997\u09a4 \u0985\u09a7\u09bf\u0995\u09be\u09b0 \u09b2\u09be\u0997\u09ac\u09c7 \u09af\u09be CREATE \u09a8\u09be\u09ae\u09c7 \u09aa\u09b0\u09bf\u099a\u09bf\u09a4\u0964 MySQLi \u098f\u09ac\u0982 PDO \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be CREATE DATABASE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2-\u098f \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4\u2026","rel":"","context":"In "\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial"","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5420,"url":"http:\/\/bangla.sitestree.com\/?p=5420","url_meta":{"origin":7731,"position":5},"title":"MySQL \u0993\u09df\u09be\u09b0\u0995\u09ac\u09c7\u09a8\u099a \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09ac\u09be\u09a8\u09be\u09ac\u09c7\u09a8\u0964 Create database from db model using MySQL workbench","author":"Sayed","date":"October 30, 2014","format":false,"excerpt":"Create database from db model using MySQL workbench","rel":"","context":"In "Root"","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/7731","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7731"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/7731\/revisions"}],"predecessor-version":[{"id":7732,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/7731\/revisions\/7732"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7731"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}