{"id":79,"date":"2020-05-26T01:51:38","date_gmt":"2020-05-25T23:51:38","guid":{"rendered":"https:\/\/cleverblog.pl\/?p=79"},"modified":"2022-01-07T22:53:53","modified_gmt":"2022-01-07T21:53:53","slug":"mysql-mariadb-dostep-z-zewnatrz","status":"publish","type":"post","link":"https:\/\/cleverblog.pl\/?p=79","title":{"rendered":"MySQL\/MariaDb &#8211; dost\u0119p z zewn\u0105trz"},"content":{"rendered":"\n<p>Serwer bazy danych MySQL\/MariaDB domy\u015blnie zezwala jedynie na po\u0142\u0105czenia z sieci lokalnej. Je\u017celi chcesz udost\u0119pni\u0107 serwer dla wszystkich interfejs\u00f3w, musisz dokona\u0107 kilku zmian w ustawieniach.<\/p>\n\n\n\n<h2>Plik konfiguracyjny<\/h2>\n\n\n\n<p>Wpierw musisz wprowadzi\u0107 zmian\u0119 w pliku konfiguracyjnym.<\/p>\n\n\n\n<p>Przejd\u017a do jego lokalizacji.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/etc\/mysql\/mariadb.conf.d<\/code><\/pre>\n\n\n\n<p>Po czym otw\u00f3rz go do edycji.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo nano 50-server.cnf<\/code><\/pre>\n\n\n\n<p>Wpierw upewnij si\u0119, \u017ce nie masz wpisanego poni\u017cszego ustawienia. Je\u017celi masz, usu\u0144 je lub zakomentuj znakiem #. Starsze wersje MySQL mia\u0142y dodany ten wpis domy\u015blnie.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#skip-networking<\/code><\/pre>\n\n\n\n<p>Znajd\u017a nast\u0119pnie wpis <em>bind-address<\/em> i podmie\u0144 jego zawarto\u015b\u0107 z tej wskazuj\u0105cej na sie\u0107 lokaln\u0105<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>bind-address = 127.0.0.0<\/code><\/pre>\n\n\n\n<p>na tak\u0105, kt\u00f3ra pozwala na po\u0142\u0105czenie z dowolnego urz\u0105dzenia w sieci.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>bind-address = 0.0.0.0<\/code><\/pre>\n\n\n\n<p>Niestety, nie ma mo\u017cliwo\u015bci dodania kilku adres\u00f3w czy przedzia\u0142u adres\u00f3w. Aby to zrobi\u0107, nale\u017cy odpowiednio skonfigurowa\u0107 firewall. Pami\u0119taj tak\u017ce, \u017ce na serwerze przechowuj\u0105cym istotne dane taka konfiguracja musi by\u0107 koniecznie wdro\u017cona! Z uwagi na prostot\u0119 tego tutorialu, nie b\u0119d\u0119 jej w nim porusza\u0107.<\/p>\n\n\n\n<h2>Uprawnienia<\/h2>\n\n\n\n<p>Serwer MySQL domy\u015blnie powinien posiada\u0107 ju\u017c tak\u0105 konfiguracj\u0119 <em>0.0.0.0<\/em> (ale sprawd\u017a dla pewno\u015bci). Je\u017celi problem wyst\u0119puje nadal, zapewne jest to wina uprawnie\u0144. W tym celu uruchom lini\u0119 polece\u0144 dla serwera, wpisuj\u0105c:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql -u root -p<\/code><\/pre>\n\n\n\n<p>Po czym nadaj odpowiedniej bazie uprawnienia:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL PRIVILEGES ON *.* TO 'YOUR_MYSQL_USERNAME'@'192.168.1.%' IDENTIFIED BY 'YOUR_MYSQL_PASSWORD' WITH GRANT OPTION;\nGRANT ALL PRIVILEGES ON *.* TO 'YOUR_MYSQL_USERNAME'@'10.8.0.%' IDENTIFIED BY 'YOUR_MYSQL_PASSWORD' WITH GRANT OPTION;<\/code><\/pre>\n\n\n\n<p>Mo\u017cesz sprawdzi\u0107 dodane wpisy poleceniem:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT User, Host FROM mysql.user WHERE Host &lt;&gt; 'localhost';<\/code><\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"640\" height=\"160\" src=\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-6.png\" alt=\"\" class=\"wp-image-80\" srcset=\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-6.png 640w, https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-6-300x75.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure><\/div>\n\n\n\n<p>Je\u017celi si\u0119 pomyli\u0142e\u015b &#8211; nic si\u0119 nie sta\u0142o. Mo\u017cesz usun\u0105\u0107 te uprawnienia analogicznym poleceniem.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Delete FROM mysql.user WHERE Host &lt;&gt; 'localhost';<\/code><\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"560\" height=\"40\" src=\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-13.png\" alt=\"\" class=\"wp-image-87\" srcset=\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-13.png 560w, https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-13-300x21.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/figure><\/div>\n\n\n\n<p>Mo\u017cesz teraz zapisa\u0107 ustawienia i wy\u0142\u0105czy\u0107 konsol\u0119 MySQL.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>FLUSH PRIVILEGES;\nexit<\/code><\/pre>\n\n\n\n<p>Pozostaje ju\u017c tylko zrestartowa\u0107 serwis.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo service mysql restart\n#lub\nsudo service mariadb restart<\/code><\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"577\" height=\"34\" src=\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-12.png\" alt=\"\" class=\"wp-image-85\" srcset=\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-12.png 577w, https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/image-12-300x18.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/figure><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Udost\u0119pnij serwer MySQL\/MariaDB poza sieci\u0105 lokaln\u0105<\/p>\n","protected":false},"author":1,"featured_media":439,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32,7],"tags":[18,17,4],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL\/MariaDb - dost\u0119p z zewn\u0105trz - cleverblog.pl<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cleverblog.pl\/?p=79\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\/MariaDb - dost\u0119p z zewn\u0105trz - cleverblog.pl\" \/>\n<meta property=\"og:description\" content=\"Udost\u0119pnij serwer MySQL\/MariaDB poza sieci\u0105 lokaln\u0105\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cleverblog.pl\/?p=79\" \/>\n<meta property=\"og:site_name\" content=\"cleverblog.pl\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-25T23:51:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-07T21:53:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"pablo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cleverblog.pl\/#website\",\"url\":\"https:\/\/cleverblog.pl\/\",\"name\":\"cleverblog.pl\",\"description\":\"Blog technologiczny\",\"publisher\":{\"@id\":\"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cleverblog.pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/cleverblog.pl\/?p=79#primaryimage\",\"url\":\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg\",\"contentUrl\":\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cleverblog.pl\/?p=79#webpage\",\"url\":\"https:\/\/cleverblog.pl\/?p=79\",\"name\":\"MySQL\/MariaDb - dost\u0119p z zewn\u0105trz - cleverblog.pl\",\"isPartOf\":{\"@id\":\"https:\/\/cleverblog.pl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cleverblog.pl\/?p=79#primaryimage\"},\"datePublished\":\"2020-05-25T23:51:38+00:00\",\"dateModified\":\"2022-01-07T21:53:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cleverblog.pl\/?p=79#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cleverblog.pl\/?p=79\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cleverblog.pl\/?p=79#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/cleverblog.pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\/MariaDb &#8211; dost\u0119p z zewn\u0105trz\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/cleverblog.pl\/?p=79#article\",\"isPartOf\":{\"@id\":\"https:\/\/cleverblog.pl\/?p=79#webpage\"},\"author\":{\"@id\":\"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246\"},\"headline\":\"MySQL\/MariaDb &#8211; dost\u0119p z zewn\u0105trz\",\"datePublished\":\"2020-05-25T23:51:38+00:00\",\"dateModified\":\"2022-01-07T21:53:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cleverblog.pl\/?p=79#webpage\"},\"wordCount\":252,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246\"},\"image\":{\"@id\":\"https:\/\/cleverblog.pl\/?p=79#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg\",\"keywords\":[\"MariaDB\",\"MySQL\",\"raspberry\"],\"articleSection\":[\"Linux\",\"Raspberry Pi\"],\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cleverblog.pl\/?p=79#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246\",\"name\":\"pablo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/cleverblog.pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cce886c6f46941b8addd14fcd58e7a5?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cce886c6f46941b8addd14fcd58e7a5?s=96&d=retro&r=g\",\"caption\":\"pablo\"},\"logo\":{\"@id\":\"https:\/\/cleverblog.pl\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/cleverblog.pl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\/MariaDb - dost\u0119p z zewn\u0105trz - cleverblog.pl","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cleverblog.pl\/?p=79","og_locale":"pl_PL","og_type":"article","og_title":"MySQL\/MariaDb - dost\u0119p z zewn\u0105trz - cleverblog.pl","og_description":"Udost\u0119pnij serwer MySQL\/MariaDB poza sieci\u0105 lokaln\u0105","og_url":"https:\/\/cleverblog.pl\/?p=79","og_site_name":"cleverblog.pl","article_published_time":"2020-05-25T23:51:38+00:00","article_modified_time":"2022-01-07T21:53:53+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"pablo","Szacowany czas czytania":"3 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/cleverblog.pl\/#website","url":"https:\/\/cleverblog.pl\/","name":"cleverblog.pl","description":"Blog technologiczny","publisher":{"@id":"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cleverblog.pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/cleverblog.pl\/?p=79#primaryimage","url":"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg","contentUrl":"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg","width":1280,"height":720},{"@type":"WebPage","@id":"https:\/\/cleverblog.pl\/?p=79#webpage","url":"https:\/\/cleverblog.pl\/?p=79","name":"MySQL\/MariaDb - dost\u0119p z zewn\u0105trz - cleverblog.pl","isPartOf":{"@id":"https:\/\/cleverblog.pl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cleverblog.pl\/?p=79#primaryimage"},"datePublished":"2020-05-25T23:51:38+00:00","dateModified":"2022-01-07T21:53:53+00:00","breadcrumb":{"@id":"https:\/\/cleverblog.pl\/?p=79#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cleverblog.pl\/?p=79"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cleverblog.pl\/?p=79#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/cleverblog.pl\/"},{"@type":"ListItem","position":2,"name":"MySQL\/MariaDb &#8211; dost\u0119p z zewn\u0105trz"}]},{"@type":"Article","@id":"https:\/\/cleverblog.pl\/?p=79#article","isPartOf":{"@id":"https:\/\/cleverblog.pl\/?p=79#webpage"},"author":{"@id":"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246"},"headline":"MySQL\/MariaDb &#8211; dost\u0119p z zewn\u0105trz","datePublished":"2020-05-25T23:51:38+00:00","dateModified":"2022-01-07T21:53:53+00:00","mainEntityOfPage":{"@id":"https:\/\/cleverblog.pl\/?p=79#webpage"},"wordCount":252,"commentCount":1,"publisher":{"@id":"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246"},"image":{"@id":"https:\/\/cleverblog.pl\/?p=79#primaryimage"},"thumbnailUrl":"https:\/\/cleverblog.pl\/wp-content\/uploads\/2020\/05\/thumbnail-mysql-mariadb-remote-access.jpg","keywords":["MariaDB","MySQL","raspberry"],"articleSection":["Linux","Raspberry Pi"],"inLanguage":"pl-PL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cleverblog.pl\/?p=79#respond"]}]},{"@type":["Person","Organization"],"@id":"https:\/\/cleverblog.pl\/#\/schema\/person\/4db06735882fd08d47316d2bc03f8246","name":"pablo","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/cleverblog.pl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cce886c6f46941b8addd14fcd58e7a5?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cce886c6f46941b8addd14fcd58e7a5?s=96&d=retro&r=g","caption":"pablo"},"logo":{"@id":"https:\/\/cleverblog.pl\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/cleverblog.pl"]}]}},"_links":{"self":[{"href":"https:\/\/cleverblog.pl\/index.php?rest_route=\/wp\/v2\/posts\/79"}],"collection":[{"href":"https:\/\/cleverblog.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cleverblog.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cleverblog.pl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cleverblog.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=79"}],"version-history":[{"count":10,"href":"https:\/\/cleverblog.pl\/index.php?rest_route=\/wp\/v2\/posts\/79\/revisions"}],"predecessor-version":[{"id":309,"href":"https:\/\/cleverblog.pl\/index.php?rest_route=\/wp\/v2\/posts\/79\/revisions\/309"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cleverblog.pl\/index.php?rest_route=\/wp\/v2\/media\/439"}],"wp:attachment":[{"href":"https:\/\/cleverblog.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=79"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cleverblog.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=79"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cleverblog.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}