{"id":8438,"date":"2019-05-22T11:24:14","date_gmt":"2019-05-22T09:24:14","guid":{"rendered":"https:\/\/blog.unelink.es\/?p=8438"},"modified":"2019-11-22T11:26:17","modified_gmt":"2019-11-22T10:26:17","slug":"reiniciar-las-bases-de-datos-mysql-desde-ssh","status":"publish","type":"post","link":"https:\/\/hosting.airetech.es\/blog\/wiki\/reiniciar-las-bases-de-datos-mysql-desde-ssh\/","title":{"rendered":"Reiniciar las bases de datos (MySQL) desde SSH"},"content":{"rendered":"\n<p>Si tienes un <a rel=\"noreferrer noopener\" href=\"https:\/\/www.unelink.es\/servidores-virtuales-33.html\" target=\"_blank\">servidor virtual<\/a> o <a rel=\"noreferrer noopener\" href=\"https:\/\/www.unelink.es\/servidores-dedicados-32.html\" target=\"_blank\">dedicado<\/a> y necesitas <strong>reiniciar el servicio de bases de datos (MySQL)<\/strong> sin acceder al panel de control instalado, puedes hacerlo <strong>desde una conexi\u00f3n por SSH<\/strong>. <\/p>\n\n\n\n<p>Lo primero que tienes que hacer es <strong>acceder al servidor por SSH<\/strong> utilizando el usuario root. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/acceso-ssh-5.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"677\" height=\"198\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/acceso-ssh-5.jpg\" alt=\"Acceso SSH\" class=\"wp-image-8439\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/acceso-ssh-5.jpg 677w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/acceso-ssh-5-300x88.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/acceso-ssh-5-600x175.jpg 600w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/a><figcaption>Acceso SSH<\/figcaption><\/figure><\/div>\n\n\n\n<p>Y <strong>ejecuta<\/strong> el siguiente comando:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/etc\/init.d\/mysql restart<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/reiniciar-mysql.png\"><img loading=\"lazy\" decoding=\"async\" width=\"677\" height=\"198\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/reiniciar-mysql.png\" alt=\"Reiniciar MySQL\" class=\"wp-image-8440\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/reiniciar-mysql.png 677w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/reiniciar-mysql-300x88.png 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2019\/05\/reiniciar-mysql-600x175.png 600w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/a><figcaption>Reiniciar MySQL<\/figcaption><\/figure><\/div>\n\n\n\n<p>Recuerda que <strong>dependiendo del motor de base de datos que tengas instalado, es posible que el comando cambie<\/strong> y en vez de reiniciar MySQL tendr\u00edas que reiniciar el servicio correspondiente.<\/p>\n\n\n\n<p>De esta forma puedes reiniciar MySQL desde la consola SSH.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"Si tienes un servidor virtual o dedicado y necesitas reiniciar el servicio de bases de datos (MySQL) sin acceder al panel de control instalado, puedes hacerlo desde una conexi\u00f3n por SSH. Lo primero que tienes que hacer es acceder al servidor por SSH utilizando el usuario root. Y ejecuta el siguiente comando: \/etc\/init.d\/mysql restart Recuerda que dependiendo del motor de&nbsp;<a href=\"https:\/\/hosting.airetech.es\/blog\/wiki\/reiniciar-las-bases-de-datos-mysql-desde-ssh\/\" class=\"read-more\">Seguir leyendo<\/a>","protected":false},"author":1,"featured_media":8440,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[12,10,118,7,8,507,515,349,6],"tags":[216,344,343,213,214,169],"class_list":["post-8438","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos","category-linux","category-mysql-2","category-servidores-dedicados","category-servidores-virtuales-vps","category-ssh-servidores-dedicados","category-ssh-servidores-virtuales-vps","category-ssh","category-wiki","tag-linux","tag-reiniciar-base-de-datos","tag-reiniciar-mysql","tag-servidores-dedicados","tag-servidores-virtuales-vps","tag-ssh","cat-12-id","cat-10-id","cat-118-id","cat-7-id","cat-8-id","cat-507-id","cat-515-id","cat-349-id","cat-6-id"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/8438","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/comments?post=8438"}],"version-history":[{"count":1,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/8438\/revisions"}],"predecessor-version":[{"id":8441,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/8438\/revisions\/8441"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media\/8440"}],"wp:attachment":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media?parent=8438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/categories?post=8438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/tags?post=8438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}