{"id":15891,"date":"2023-10-06T12:47:25","date_gmt":"2023-10-06T18:47:25","guid":{"rendered":"https:\/\/sada.services\/?p=15891"},"modified":"2023-10-06T12:47:25","modified_gmt":"2023-10-06T18:47:25","slug":"mysql-cambiar-password","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=15891","title":{"rendered":"MYSQL: Cambiar password"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>Ingresamos con <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creamos usuario<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'sigetic'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'Remoto_BAS_0';\n\nGRANT ALL PRIVILEGES ON bd_sis_sada_sigetic.* TO 'sigetic'@'localhost';\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Alter<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT USAGE ON *.* TO 'remoto'@'localhost' IDENTIFIED BY 'Remoto_BAS_0';\nSET PASSWORD FOR 'remoto'@'localhost' = PASSWORD('Remoto_BAS_0');\n\nALTER USER 'remoto'@'localhost' IDENTIFIED BY 'Remoto_BAS_0';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">ERROR: [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: \u00bbmysql_native_password&#8217; is deprecated and will be removed in a future release. Please use caching_sha2_password instead&#8217;<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verificar quienes lo utilizan<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT user, host, plugin FROM mysql.user WHERE plugin = 'mysql_native_password';\n\nSELECT user, host, plugin FROM mysql.user WHERE plugin = 'caching_sha2_password';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Eliminar usuario<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP USER 'remoto'@'localhost';<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SYSTEM_USER ON *.* TO 'root'@'%';\n\nALTER USER 'remoto'@'%' IDENTIFIED WITH 'caching_sha2_password' BY 'Remoto_BAS_0';\n\nALTER USER 'root'@'%' IDENTIFIED WITH 'caching_sha2_password' BY 'Hefesto_BAS_0';\n\nREVOKE SYSTEM_USER ON *.* FROM 'root'@'%';\n\nexit\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ERROR: [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: \u00bbmysql_native_password&#8217; is deprecated and will be removed in a future release. Please use caching_sha2_password instead&#8217;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-15891","post","type-post","status-publish","format-standard","hentry","category-mysql"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/15891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15891"}],"version-history":[{"count":1,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/15891\/revisions"}],"predecessor-version":[{"id":15894,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/15891\/revisions\/15894"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}