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”);<\/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
details: http:\/\/www.keithjbrown.co.uk\/vworks\/mysql\/mysql_pA.php#secure From: http:\/\/sitestree.com\/?p=4721
Categories:5
Tags:
Post Data:2007-02-12 07:44:59<\/p>\n
Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n 8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"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 -> WHERE (db.Db LIKE … <\/p>\n