{"id":873,"date":"2019-06-29T16:32:07","date_gmt":"2019-06-29T19:32:07","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=873"},"modified":"2019-06-29T16:32:07","modified_gmt":"2019-06-29T19:32:07","slug":"error-3185-hy000-cant-find-master-key-from-keyring-please-check-in-the-server-log-if-a-keyring-plugin-is-loaded-and-initialized-successfully","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/06\/29\/error-3185-hy000-cant-find-master-key-from-keyring-please-check-in-the-server-log-if-a-keyring-plugin-is-loaded-and-initialized-successfully\/","title":{"rendered":"ERROR 3185 (HY000): Can&#8217;t find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully."},"content":{"rendered":"<p><strong>Erro ao tentar criar a tabela criptografada<\/strong><\/p>\n<pre class=\"lang:mysql decode:true\">mysql&gt; CREATE TABLE faturamento (empresa varchar(50), fatura int)\n\t\tENGINE=InnoDB ENCRYPTION='Y';\n\t\t\nERROR 3185 (HY000): Can't find master key from keyring, please check in the server \nlog if a keyring plugin is loaded and initialized successfully.<\/pre>\n<p><strong>Verificando plugin instalado<\/strong><\/p>\n<pre class=\"lang:mysql decode:true \">mysql&gt; show variables like '%keyring%';\n+--------------------+-------+\n| Variable_name      | Value |\n+--------------------+-------+\n| keyring_operations | ON    |\n+--------------------+-------+\n1 row in set (0.00 sec)<\/pre>\n<p><strong>Instalando o plugin &#8216;keyring_file.so&#8217;<\/strong><\/p>\n<pre class=\"lang:mysql decode:true \">mysql&gt; install plugin keyring_file soname 'keyring_file.so';\nQuery OK, 0 rows affected (0.01 sec)\n<\/pre>\n<p><strong>Verificando plugin instalado<\/strong><\/p>\n<pre class=\"lang:mysql decode:true\">mysql&gt; show variables like '%keyring%';\n+--------------------+--------------------------------+\n| Variable_name      | Value                          |\n+--------------------+--------------------------------+\n| keyring_file_data  | \/var\/lib\/mysql-keyring\/keyring |\n| keyring_operations | ON                             |\n+--------------------+--------------------------------+\n2 rows in set (0.00 sec)<\/pre>\n<p><strong>Criando tabela criptografada<\/strong><\/p>\n<pre class=\"lang:mysql decode:true \">mysql&gt; CREATE TABLE faturamento (empresa varchar(50), fatura int)\n    -&gt; ENGINE=InnoDB ENCRYPTION='Y';\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Erro ao tentar criar a tabela criptografada mysql&gt; CREATE TABLE faturamento (empresa varchar(50), fatura int) ENGINE=InnoDB ENCRYPTION=&#8217;Y&#8217;; ERROR 3185 (HY000): Can&#8217;t find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully. Verificando plugin instalado mysql&gt; show variables like &#8216;%keyring%&#8217;; +&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;-+ | Variable_name | Value |&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[129,293],"class_list":["post-873","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-error-3185-hy000-cant-find-master-key-from-keyring","tag-please-check-in-the-server-log-if-a-keyring-plugin-is-loaded-and-initialized-successfully"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/873","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=873"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/873\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}