{"id":5280,"date":"2013-07-17T12:36:57","date_gmt":"2013-07-17T10:36:57","guid":{"rendered":"http:\/\/www.palentino.es\/blog\/?p=5280"},"modified":"2013-07-17T12:40:01","modified_gmt":"2013-07-17T10:40:01","slug":"configurar-acceso-remoto-a-mysql","status":"publish","type":"post","link":"https:\/\/www.palentino.es\/blog\/configurar-acceso-remoto-a-mysql\/","title":{"rendered":"Configurar acceso remoto a Mysql"},"content":{"rendered":"<div id=\"palen-2504214896\" class=\"palen-antes-del-contenido palen-entity-placement\"><div class=\"palen-adlabel\">Anuncios<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2815317153396146\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-2815317153396146\" \ndata-ad-slot=\"4593837716\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><p>En esta entrada mostrar\u00e9 como crear una base Mysql, comprobar su estado, dar acceso externo para el control de la base desde un Frontend (ejemplo <a href=\"http:\/\/www.mysqlfront.de\/\" target=\"_blank\">mysqlfront<\/a>), en modo comando o terminal remoto. Mediante <a href=\"http:\/\/www.chiark.greenend.org.uk\/~sgtatham\/putty\/download.html\" target=\"_blank\">putty <\/a>u otro tipo de software.<\/p>\n<p>De forma r\u00e1pida &#8230;<\/p>\n<p><!--more--><\/p>\n<p>Crear base de datos:<br \/>\n<strong>CREATE DATABASE prueba;<\/strong><\/p>\n<p>Comprobar base de datos:<br \/>\n<strong>SHOW DATABASES;<\/strong><\/p>\n<p>Crear usuario<br \/>\n<strong>GRANT ALL PRIVILEGES ON basedatos.tablas TO usuario[@opcionalIP] IDENTIFIED BY &#8216;contrase\u00f1a&#8217;;<\/strong><\/p>\n<p>Ejemplo:<br \/>\nGRANT ALL PRIVILEGES ON nombre_base.* TO &#8216;nombre_usuario&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;contrase\u00f1a&#8217;;<\/p>\n<p>Comprobar usuario.<br \/>\n<strong>SHOW GRANTS FOR usuario;<\/strong><\/p>\n<p>En el fichero my.conf dentro del \u00a0etc,\u00a0modificar la l\u00ednea:<\/p>\n<p><strong>&#8220;bind-address = 127.0.0.1&#8221;, <\/strong><\/p>\n<p><strong>por &#8220;bind-address = 0.0.0.0&#8221;<\/strong><\/p>\n<p>Luego comprobar:<\/p>\n<p><strong>grant all privileges on *.* to &#8216;usuario&#8217;@&#8217;%&#8217; identified by &#8216;password&#8217; with grant option;<\/strong><\/p>\n<p>Y finalmente reiniciar el servidor mysql.<br \/>\n<strong>\/etc\/init.d\/mysql restart<\/strong><\/p>\n<p>\u00f3 ejecutar<\/p>\n<p><strong>service mysqld restart<\/strong><\/p>\n<p>&nbsp;<\/p>\n<div id=\"palen-2778034151\" class=\"palen-despues-del-contenido palen-entity-placement\"><div class=\"palen-adlabel\">Anuncios<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2815317153396146\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-2815317153396146\" \ndata-ad-slot=\"\" \ndata-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>En esta entrada mostrar\u00e9 como crear una base Mysql, comprobar su estado, dar acceso externo para el control de la base desde un Frontend (ejemplo mysqlfront), en modo comando o terminal remoto. Mediante putty u otro tipo de software. De forma r\u00e1pida &#8230;<\/p>\n","protected":false},"author":1,"featured_media":4871,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[40,295,438,14],"tags":[37],"class_list":["post-5280","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos","category-sql-2","category-sysadmin-2","category-varios","tag-mysql"],"views":4769,"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2013\/05\/Mysql.jpg","jetpack_shortlink":"https:\/\/wp.me\/p2ECph-1na","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/5280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/comments?post=5280"}],"version-history":[{"count":5,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/5280\/revisions"}],"predecessor-version":[{"id":5284,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/5280\/revisions\/5284"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/media\/4871"}],"wp:attachment":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/media?parent=5280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/categories?post=5280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/tags?post=5280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}