{"id":228926,"date":"2022-11-02T20:07:00","date_gmt":"2022-11-02T17:07:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=228926"},"modified":"2022-11-09T04:50:02","modified_gmt":"2022-11-09T01:50:02","slug":"kuidas-teha-mysql-uelemaailmselt-juurdepaeaesetavaks-mamp-ist","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/et\/kuidas-teha-mysql-uelemaailmselt-juurdepaeaesetavaks-mamp-ist\/","title":{"rendered":"Kuidas teha MySQL \u00fclemaailmselt juurdep\u00e4\u00e4setavaks (MAMP-ist)"},"content":{"rendered":"<p>R\u00e4\u00e4kisin hiljuti l\u00e4bi, kuidas <a href=\"https:\/\/wordpress.mediadoma.com\/et\/uelemaailmne-wp-cli-installimine-teie-suesteemile-juurdepaeaesuks\/\" title=\"WP-CLI\" >WP-CLI<\/a> teie s\u00fcsteemis \u00fclemaailmselt juurdep\u00e4\u00e4setavaks teha (eeldusel, et kasutate MacOS-i v\u00f5i Linuxi variatsiooni).<\/p>\n<p>Olen r\u00e4\u00e4kinud ka erinevatest asjadest, mis on seotud <a href=\"https:\/\/wordpress.mediadoma.com\/et\/xdebug-visual-studio-code-ja-mamp\/\" title=\"MAMP Pro kasutamisega WordPressi arendamiseks\" >MAMP Pro kasutamisega WordPressi arendamiseks<\/a>. Loomulikult on \u00fcks neist t\u00f6\u00f6riistadest ka MySQL; Siiski k\u00e4sitletakse seda sageli kui &quot;seadista ja unusta&quot; rakendust.<\/p>\n<p>Kuid ma hakkasin hiljuti t\u00f6\u00f6tama projekti kallal, mis n\u00f5uab arendus- ja lavastusandmebaaside s\u00fcnkroonimisega pisut automatiseerimist. Ja kuna see on skriptitud, eeldatakse, et MySQL on \u00fclemaailmselt saadaval.<\/p>\n<p>Kui ainus viis MySQL-i installimiseks on MAMP-i (v\u00f5i m\u00f5ne muu sarnase paketi) kaudu, peate t\u00f5en\u00e4oliselt muutma MySQL-i oma s\u00fcsteemis \u00fclemaailmselt juurdep\u00e4\u00e4setavaks.<\/p>\n<p>Siin on, kuidas seda teha.<\/p>\n<h2>Tehke MySQL \u00fclemaailmselt juurdep\u00e4\u00e4setavaks<\/h2>\n<p>Seda saab teha v\u00e4hemalt kahel viisil ja erinevad inimesed eelistavad nende meetodit. N\u00e4iteks v\u00f5ivad m\u00f5ned soovid v\u00e4rskendada oma bash-profiili, et m\u00e4\u00e4rata, kus k\u00e4ivitatav fail asub. Teised v\u00f5ivad valida s\u00fcmboolse lingi seadmise.<\/p>\n<p>Kuna olen eelmises postituses jaganud, kuidas bash-profiiliga midagi sarnast teha, siis siin on lihtne viis seda teha s\u00fcmboolse linkimise kaudu.<\/p>\n<p>Oletame, et MySQL asub j\u00e4rgmisel teel:<\/p>\n<pre><code>\/Applications\/MAMP\/Library\/bin\/mysql<\/code><\/pre>\n<p>Sisestage terminali (ja seej\u00e4rel vajutage sisestusklahvi):<\/p>\n<pre><code>ln -s ~<\/code><\/pre>\n<p>See loob kataloogis usr\/local\/bin s\u00fcmboolse lingi, mis viitab MAMP Pro-ga tarnitavale MySQL-i kahendfailile.<\/p>\n<p>See on lihtne ja sarnaneb muude asjadega, millega v\u00f5ite kokku puutuda (nt <a href=\"https:\/\/wordpress.mediadoma.com\/et\/visual-studio-koodi-saetete-jagamine-dropboxis\/\" title=\"IDE-seadete s\u00fcnkroonimine\" >IDE-seadete s\u00fcnkroonimine<\/a> ), nii et see pole midagi v\u00e4ljam\u00f5eldud. Kuid kui t\u00f6\u00f6tate projekti v\u00f5i projekti osa kallal, mis n\u00f5uab skriptimist, mis tugineb andmebaasile, saate nii tagada, et sama MySQL-i versiooni kasutatakse nii teie veebiserveri kui ka k\u00f5igi nimetatud skriptidega.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/tommcfarlin.com\" class=\"external external_icon\">tommcfarlin.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kui ainus viis MySQL-i installimiseks on MAMP-i kaudu, peate t\u00f5en\u00e4oliselt muutma MySQL-i oma s\u00fcsteemis \u00fclemaailmselt juurdep\u00e4\u00e4setavaks. Siin on, kuidas.<\/p>\n","protected":false},"author":1,"featured_media":224028,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[718,894,842,863],"tags":[1165],"class_list":["post-228926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-arendaja","category-kood","category-opetused","category-wordpress-4","tag-affiai-et"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/228926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/comments?post=228926"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/228926\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media\/224028"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media?parent=228926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/categories?post=228926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/tags?post=228926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}