{"id":16921,"date":"2012-11-19T12:44:01","date_gmt":"2012-11-19T10:44:01","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=16921"},"modified":"2012-11-19T12:44:01","modified_gmt":"2012-11-19T10:44:01","slug":"i-am-a-dummy","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2012\/11\/19\/i-am-a-dummy\/","title":{"rendered":"–i-am-a-dummy"},"content":{"rendered":"\n

Here is a handy command-line option<\/a> for MySQL client: –i-am-a-dummy<\/em><\/strong>, or, if you don’t have a sense of humor, –safe-updates<\/em><\/strong>. \u00a0When used, this will prevent updating or deleting rows without\u00a0explicitly\u00a0specifying a WHERE<\/em> clause. \u00a0It will also limit the number of SELECT<\/em> and JOIN<\/em> results.<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

Here is a handy command-line option for MySQL client: –i-am-a-dummy, or, if you don’t have a sense of humor, –safe-updates. \u00a0When used, this will prevent updating or deleting rows without\u00a0explicitly\u00a0specifying a WHERE clause. \u00a0It will also limit the number of SELECT and JOIN results.<\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,18,133,62],"tags":[1559,3066,200],"keyring_services":[],"class_list":["post-16921","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-sysadmin","category-technology","tag-databases","tag-mysql","tag-security"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":28263,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/11\/30\/change-sql-mode-for-mariadb-in-fedora-27\/","url_meta":{"origin":16921,"position":0},"title":"Change SQL mode for MariaDB in Fedora 27","author":"Leonid Mamchenkov","date":"November 30, 2017","format":false,"excerpt":"After I upgraded my laptop to Fedora 27, I started experiencing some weird issues with most of the projects I am developing locally.\u00a0 Trying to save anything into the database that involves dates, started throwing the following errors: A quick look around showed that Fedora 27 ships MariaDB v10.2, while\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27380,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/03\/02\/mysql-8-is-coming\/","url_meta":{"origin":16921,"position":1},"title":"MySQL 8 is coming","author":"Leonid Mamchenkov","date":"March 2, 2017","format":false,"excerpt":"OpenSource.com covers the upcoming release of the MySQL 8. What happened to 6 & 7? Years ago, before the Sun Microsystems purchase of MySQL AB, there was a version of MySQL with the number 6. Sadly, it was a bit ambitious and the change of ownership left it to wither.\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24,"url":"https:\/\/mamchenkov.net\/wordpress\/2002\/03\/08\/mysql-password-recovery\/","url_meta":{"origin":16921,"position":2},"title":"MySQL password recovery","author":"Leonid Mamchenkov","date":"March 8, 2002","format":false,"excerpt":"It often happens so that administrator's password for MySQL is lost or forgotten. The easiest way to fix the problem is to open \/var\/lib\/mysql\/mysql\/user.MYD in hex editor and replace the encrypted string near \"localhost root\" with spaces. Then mysql service should be restarted, and that's it.","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":23757,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/03\/24\/mysql-in-star-topology\/","url_meta":{"origin":16921,"position":3},"title":"MySQL in star topology","author":"Leonid Mamchenkov","date":"March 24, 2015","format":"link","excerpt":"MySQL in star topology","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12790,"url":"https:\/\/mamchenkov.net\/wordpress\/2010\/07\/23\/on-scalability-of-mysql\/","url_meta":{"origin":16921,"position":4},"title":"On scalability of MySQL","author":"Leonid Mamchenkov","date":"July 23, 2010","format":false,"excerpt":"Anyone who says that MySQL is not scalable has no idea. \u00a0Facebook is one of the examples for a large deployment of MySQL: How big is Facebook\u2019s Internet infrastructure? Facebook VP of Technology Jeff Rothschild provided some details in a panel at the recent MySQL user conference. Rothschild says Facebook\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28186,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/11\/06\/mysql-vs-mariadb-reality-check\/","url_meta":{"origin":16921,"position":5},"title":"MySQL vs. MariaDB: Reality Check","author":"Leonid Mamchenkov","date":"November 6, 2017","format":false,"excerpt":"Percona Database Performance Blog runs this post -\u00a0MySQL vs. MariaDB: Reality Check - comparing the MySQL, MariaDB and the Percona Server for MySQL.\u00a0 I think that most people using MySQL or MariaDB today consider them to be pretty much identical (a fork for legal reasons or something along those lines).\u00a0\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/16921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=16921"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/16921\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=16921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=16921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=16921"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=16921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}