{"id":23198,"date":"2021-03-26T20:15:33","date_gmt":"2021-03-27T00:15:33","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/securing-mysql-database-root-by-sayed-ahmed\/"},"modified":"2021-03-26T20:15:33","modified_gmt":"2021-03-27T00:15:33","slug":"securing-mysql-database-root-by-sayed-ahmed","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=23198","title":{"rendered":"Securing MySQL Database #Root #By Sayed Ahmed"},"content":{"rendered":"

Mainly deals with TestDb<\/p>\n

<\/div>\n
<\/div>\n
<\/div>\n

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.<\/p>\n

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

— SELECT db.Host, db.Db, db.User, db.Select_priv -> FROM db WHERE (db.DB = “vworksDB”); From: http:\/\/sitestree.com\/?p=3661
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2016-09-15 14:19:47<\/p>\n

\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com<\/a>
\n\t\tIn Bengali: http:\/\/Bangla.SaLearningSchool.com<\/a>
\n\t\thttp:\/\/SitesTree.com<\/a>
\n\t\t8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>
\n\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\tMedium: https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Mainly deals with TestDb 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”); From: http:\/\/sitestree.com\/?p=3661 Categories:Root, By Sayed … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-23198","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69093,"url":"http:\/\/bangla.sitestree.com\/?p=69093","url_meta":{"origin":23198,"position":0},"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":22863,"url":"http:\/\/bangla.sitestree.com\/?p=22863","url_meta":{"origin":23198,"position":1},"title":"MySQL Workbench Create database model and miscellaneous #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 21, 2021","format":false,"excerpt":"MySQL Workbench Create database model and miscellaneous [youtube http:\/\/www.youtube.com\/watch?v=ntLq9m2CypI?feature=player_detailpage&w=640&h=360] From: http:\/\/sitestree.com\/?p=1597 Categories:Root, By Sayed AhmedTags: Post Data:2014-10-27 19:34:27 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","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":22960,"url":"http:\/\/bangla.sitestree.com\/?p=22960","url_meta":{"origin":23198,"position":2},"title":"Create Database from DB model using MySQL Workbench #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 22, 2021","format":false,"excerpt":"Create database from db model using MySQL Workbench [youtube http:\/\/www.youtube.com\/watch?v=NWFDzlBE068?feature=player_detailpage&w=640&h=360] From: http:\/\/sitestree.com\/?p=1628 Categories:Root, By Sayed AhmedTags: Post Data:2014-10-30 20:03:26 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","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":70313,"url":"http:\/\/bangla.sitestree.com\/?p=70313","url_meta":{"origin":23198,"position":3},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS #nothing","author":"Author-Check- Article-or-Video","date":"September 1, 2021","format":false,"excerpt":"RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are\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":70315,"url":"http:\/\/bangla.sitestree.com\/?p=70315","url_meta":{"origin":23198,"position":4},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS #nothing","author":"Author-Check- Article-or-Video","date":"September 1, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\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":70317,"url":"http:\/\/bangla.sitestree.com\/?p=70317","url_meta":{"origin":23198,"position":5},"title":"Learn some Centos\/Redhat Linux: RHCE: MariaDB Administration on Redhat\/Fedora\/CentOS #nothing","author":"Author-Check- Article-or-Video","date":"September 1, 2021","format":false,"excerpt":"The author is: the_authornRHCE: MariaDB Administration on Redhat\/Fedora\/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL - after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see - installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7\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":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/23198","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=23198"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/23198\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23198"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}