{"id":601,"date":"2006-11-18T17:19:53","date_gmt":"2006-11-18T15:19:53","guid":{"rendered":"http:\/\/www.marblestation.com\/blog\/?p=601"},"modified":"2012-04-26T16:56:18","modified_gmt":"2012-04-26T14:56:18","slug":"bugs-de-mysql-admin-en-ubuntu-edgy","status":"publish","type":"post","link":"https:\/\/www.marblestation.com\/?p=601","title":{"rendered":"Bugs de mysql-admin en Ubuntu Edgy"},"content":{"rendered":"<p><img decoding=\"async\" src=\"http:\/\/www.mysql.com\/products\/tools\/administrator\/mysqladmin_users-small.png\" align=\"right\"\/> Si necesitamos trabajar y administrar una MySQL (ya sea en nuestra m\u00e1quina o en remoto) podemos utilizar la interfaz <a href=\"http:\/\/www.mysql.com\/products\/tools\/administrator\/\">mysql-admin<\/a> para la administraci\u00f3n y <a href=\"http:\/\/www.mysql.com\/products\/tools\/query-browser\/\">mysql-query-browser<\/a> para realizar consultas. Por desgracia, en Ubuntu Edgy mysql-admin tiene un par de bugs.<\/p>\n<p>El primero de ellos es un <a href=\"https:\/\/launchpad.net\/distros\/ubuntu\/+source\/mysql-admin\/+bug\/29802\">molesto error<\/a> que nos impide acceder a la administraci\u00f3n de usuarios. Para evitarlo podemos crear un fichero &#8216;\/usr\/local\/bin\/mysql-admin-fixed.sh&#8217;:<\/p>\n<pre>\r\n#!\/bin\/bash\r\nexport DEBUG_DONT_SPAWN_FETCHES=1\r\nmysql-admin\r\n<\/pre>\n<p>Y le damos permisos de ejecuci\u00f3n:<\/p>\n<pre>\r\nsudo chmod 755 \/usr\/local\/bin\/mysql-admin-fixed.sh\r\n<\/pre>\n<p>A partir de ahora, para ejecutar mysql-admin utilizaremos:<\/p>\n<pre>\r\nmysql-admin-fixed.sh\r\n<\/pre>\n<p>El segundo bug nos impide acceder a la configuraci\u00f3n de la base de datos, para arreglarlo simplemente tendremos que editar &#8216;\/etc\/mysql\/my.cnf&#8217; y comentar la l\u00ednea que dice:<\/p>\n<pre>\r\n#skip-external-locking\r\n<\/pre>\n<p>Con esto ya podemos utilizar mysql-admin m\u00e1s c\u00f3modamente \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si necesitamos trabajar y administrar una MySQL (ya sea en nuestra m\u00e1quina o en remoto) podemos utilizar la interfaz mysql-admin para la administraci\u00f3n y mysql-query-browser para realizar consultas. Por desgracia, en Ubuntu Edgy mysql-admin tiene un par de bugs. El primero de ellos es un molesto error que nos impide acceder a la administraci\u00f3n de &hellip; <a href=\"https:\/\/www.marblestation.com\/?p=601\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Bugs de mysql-admin en Ubuntu Edgy<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,6],"tags":[],"class_list":["post-601","post","type-post","status-publish","format-standard","hentry","category-espanyol","category-tecnologia"],"_links":{"self":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts\/601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=601"}],"version-history":[{"count":1,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts\/601\/revisions"}],"predecessor-version":[{"id":1319,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=\/wp\/v2\/posts\/601\/revisions\/1319"}],"wp:attachment":[{"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.marblestation.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}