{"id":185,"date":"2015-07-06T04:26:16","date_gmt":"2015-07-06T04:26:16","guid":{"rendered":"http:\/\/arkahost.com\/?p=185"},"modified":"2017-07-06T14:52:44","modified_gmt":"2017-07-06T19:52:44","slug":"como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1","status":"publish","type":"post","link":"https:\/\/andino.host\/en\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/","title":{"rendered":"How to update MySQL hash\/password to secure version 4.1?"},"content":{"rendered":"

For MySQL users<\/h2>\n

(with cPanel prefix cpanel_user format)<\/h4>\n
    \n
  1. Enter cPanel and look for the section\u00a0Database \/ Databases<\/strong><\/li>\n
  2. Use the option\u00a0MySQL Database \/ MySQL Databases
    \n\"\"\u00a0\u00a0\u00a0<\/strong><\/li>\n
  3. Within this option in the final section you will find\u00a0Current Users\u00a0<\/strong>and two columns one call\u00a0Actions<\/strong>\u00a0Below this find the option\u00a0Change password \/ Change password
    \n<\/strong>\"\"<\/strong><\/li>\n
  4. By clicking on\u00a0Change password \/ Change password<\/strong>\u00a0The new password or current password must be entered so that it can be updated with the new one.\u00a0hash<\/em>\u00a0from MySQL<\/li>\n<\/ol>\n

     <\/p>\n

    For cPanel user<\/h2>\n

    (without prefix or _ character)<\/h4>\n
      \n
    1. Enter cPanel and look for the section\u00a0Preferences \/ Preferences<\/strong><\/li>\n
    2. Use the option\u00a0Password & security
      \n\"\"<\/strong><\/strong><\/li>\n
    3. Within this option the section of\u00a0Password<\/strong>\u00a0to change the password with a new data which will be the new login password to cPanel, FTP and main MySQL
      \n\"\"<\/strong><\/li>\n<\/ol>\n

      Errors that can be generated with an outdated hash<\/h3>\n
        \n
      • Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"

        For MySQL users (with cPanel prefix cpanel_user format) Enter the cPanel and look for the Database \/ Databases section Use the MySQL Database \/ MySQL Databases option Within this option in the final section is Current Users \/ Current Users and two columns, one called Actions \/ Actions below this [\u2026]<\/p>","protected":false},"author":1,"featured_media":2576,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[50,51],"yst_prominent_words":[879,97,877,853,857,858,860,802,851,847,875,849,845,862,868,864,873,866,855,871],"class_list":["post-185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-tutoriales","tag-base-de-datos","tag-mysql"],"yoast_head":"\n\u00bfC\u00f3mo actualizar hash\/contrase\u00f1a de MySQL a la versi\u00f3n segura 4.1? – AndinoHost<\/title>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/andino.host\/en\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfC\u00f3mo actualizar hash\/contrase\u00f1a de MySQL a la versi\u00f3n segura 4.1? – AndinoHost\" \/>\n<meta property=\"og:description\" content=\"Para usuarios de MySQL (con prefijo de cPanel formato cpanel_usuario) Ingresar al cPanel y buscar la seccion de\u00a0Base de datos \/ Databases Usar la opcion de\u00a0Base de datos MySQL \/ MySQL Databases \u00a0\u00a0\u00a0 Dentro de esta opci\u00f3n en la seccion final se encuentra\u00a0Usuarios actuales \/ Current Users\u00a0y dos columnas una llamada\u00a0Acciones \/ Actions\u00a0debajo de esta […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/andino.host\/en\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/\" \/>\n<meta property=\"og:site_name\" content=\"AndinoHost\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/andean.me\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-06T04:26:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-07-06T19:52:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/andino.host\/wp-content\/uploads\/2015\/07\/mysql-logo900.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1302\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@AndeanHost\" \/>\n<meta name=\"twitter:site\" content=\"@AndeanHost\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Organization\",\"Place\"],\"@id\":\"https:\/\/andino.host\/en\/#organization\",\"name\":\"AndinoHost\",\"url\":\"https:\/\/andino.host\/en\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/andean.me\",\"https:\/\/twitter.com\/AndeanHost\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/andino.host\/en\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/andino.host\/wp-content\/uploads\/2019\/10\/logo-andino-host.png\",\"width\":310,\"height\":60,\"caption\":\"AndinoHost\"},\"image\":{\"@id\":\"https:\/\/andino.host\/en\/#logo\"},\"location\":{\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#local-place\"},\"address\":{\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#local-place-address\"},\"email\":\"ventas@andean.me\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/andino.host\/en\/#website\",\"url\":\"https:\/\/andino.host\/en\/\",\"name\":\"AndinoHost\",\"description\":\"Web Hosting, Dominios, VPS, Servidores dedicados y Certificados SSL\",\"publisher\":{\"@id\":\"https:\/\/andino.host\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/andino.host\/en\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/andino.host\/wp-content\/uploads\/2015\/07\/mysql-logo900.jpg\",\"width\":1302,\"height\":376,\"caption\":\"Mysql\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#webpage\",\"url\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/\",\"name\":\"\\u00bfC\\u00f3mo actualizar hash\/contrase\\u00f1a de MySQL a la versi\\u00f3n segura 4.1? – AndinoHost\",\"isPartOf\":{\"@id\":\"https:\/\/andino.host\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#primaryimage\"},\"datePublished\":\"2015-07-06T04:26:16+00:00\",\"dateModified\":\"2017-07-06T19:52:44+00:00\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/\"]}]},{\"@type\":\"NewsArticle\",\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#webpage\"},\"author\":{\"@id\":\"https:\/\/andino.host\/en\/#\/schema\/person\/3995009b27466c3b4c9cd4819f97ffd4\"},\"headline\":\"\\u00bfC\\u00f3mo actualizar hash\/contrase\\u00f1a de MySQL a la versi\\u00f3n segura 4.1?\",\"datePublished\":\"2015-07-06T04:26:16+00:00\",\"dateModified\":\"2017-07-06T19:52:44+00:00\",\"commentCount\":0,\"mainEntityOfPage\":{\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#webpage\"},\"publisher\":{\"@id\":\"https:\/\/andino.host\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#primaryimage\"},\"keywords\":\"Base de Datos,MySql\",\"articleSection\":\"Base de Datos,Tutoriales\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#respond\"]}],\"copyrightYear\":\"2015\",\"copyrightHolder\":{\"@id\":\"https:\/\/andino.host\/en\/#organization\"}},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/andino.host\/en\/#\/schema\/person\/3995009b27466c3b4c9cd4819f97ffd4\",\"name\":\"andinohost\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/andino.host\/en\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba2458f0b4318d6218a3ebfe951a7ee920619c5e5c11bd08e44eeb7a5def7eea?s=96&d=mm&r=g\",\"caption\":\"andinohost\"}},{\"@type\":\"Place\",\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#local-place\",\"address\":{\"@type\":\"PostalAddress\",\"@id\":\"https:\/\/andino.host\/como-actualizar-hashcontrasena-de-mysql-a-la-version-segura-4-1\/#local-place-address\",\"streetAddress\":\"Jr. Victor Cordero 829\",\"addressLocality\":\"Huaraz\",\"postalCode\":\"02001\",\"addressRegion\":\"Ancash\",\"addressCountry\":\"PE\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":\"\",\"longitude\":\"\"},\"openingHoursSpecification\":[{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\",\"Sunday\"],\"opens\":\"09:00\",\"closes\":\"17:00\"}]}]}<\/script>\n<meta name=\"geo.placename\" content=\"Huaraz\" \/>\n<meta name=\"geo.region\" content=\"Peru\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/posts\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":0,"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/media\/2576"}],"wp:attachment":[{"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/tags?post=185"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/andino.host\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}