{"id":1667,"date":"2015-11-29T15:27:00","date_gmt":"2015-11-29T21:27:00","guid":{"rendered":"http:\/\/linuxitos.com\/main\/instalar-mysql-5-7-x-en-fedora-23\/"},"modified":"2015-11-29T15:27:00","modified_gmt":"2015-11-29T21:27:00","slug":"instalar-mysql-5-7-x-en-fedora-23","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/instalar-mysql-5-7-x-en-fedora-23\/","title":{"rendered":"Instalar MySQL 5.7.x en Fedora 23"},"content":{"rendered":"<div dir=\"ltr\" style=\"text-align: left;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"480\" src=\"http:\/\/2.bp.blogspot.com\/-OTWCaMHLKbE\/VkVv9R-kRLI\/AAAAAAAABg8\/xxdBlUF532I\/s640\/mysql.jpg\" width=\"640\" \/><br \/>1.- Instalar el repositorio oficial de MySQL<\/p>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">sudo dnf -y localinstall http:\/\/dev.mysql.com\/get\/mysql57-community-release-fc23-7.noarch.rpm<\/span><\/pre>\n<p>2.-&nbsp; Actualizar repositorios:<\/p>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">sudo dnf -y update<\/span><\/pre>\n<p>Antes que nada, configurar la versi\u00f3n a utilizar en los repositorios de MySQL, para esto ejecutar los siguientes comandos:<\/p>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\"><b><code>sudo dnf config-manager --enable mysql57-community<\/code><\/b><\/span><\/pre>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\"><b><code><b><code>sudo dnf repolist enabled | grep \"mysql.*-community.*\"<\/code><\/b><\/code><\/b><\/span><\/pre>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\"><b><code>sudo dnf -y update<\/code><\/b><\/span><\/pre>\n<p>&nbsp;3.- Instalar MySQL<\/p>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">sudo dnf -y install mysql-community-server<\/span><\/pre>\n<p>4.- Iniciar el servicio de MySQL<\/p>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">sudo systemctl start mysql.service<\/span><\/pre>\n<div style=\"text-align: justify;\">5.- Antes de proseguir con la configuraci\u00f3n de MySQL es necesario buscar la contrase\u00f1a temporal que se le asigna al servidor con el siguiente comando:<\/div>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">sudo grep 'temporary password' \/var\/log\/mysqld.log<\/span><\/pre>\n<div style=\"text-align: justify;\">Ah\u00ed se mostrar\u00e1 la contrase\u00f1a, ahora as\u00ed, ejecutar el comando:<\/div>\n<div style=\"text-align: justify;\"><\/div>\n<div style=\"text-align: justify;\">6.-&nbsp; Configurar MySQL:<\/div>\n<div style=\"text-align: justify;\">\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\"><b><code>mysql_secure_installation<\/code><\/b><\/span><\/pre>\n<\/div>\n<div style=\"text-align: justify;\"><\/div>\n<div style=\"text-align: justify;\">Y continuar con el establecimiento de contrase\u00f1a de root, eliminar los usuarios anonimos, etc.<\/div>\n<div style=\"text-align: justify;\"><\/div>\n<div style=\"text-align: justify;\">Lo habitual de estos comandos:<\/div>\n<div style=\"text-align: justify;\">\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">Set root password? [Y\/n] Y<br \/>New password: <br \/>Re-enter new password: <br \/>Password updated successfully!<br \/>Reloading privilege tables..<br \/> ... Success!<br \/><br \/><br \/>By default, a MySQL installation has an anonymous user, allowing anyone<br \/>to log into MySQL without having to have a user account created for<br \/>them.  This is intended only for testing, and to make the installation<br \/>go a bit smoother.  You should remove them before moving into a<br \/>production environment.<br \/><br \/>Remove anonymous users? [Y\/n] Y<br \/> ... Success!<br \/><br \/>Normally, root should only be allowed to connect from 'localhost'.  This<br \/>ensures that someone cannot guess at the root password from the network.<br \/><br \/>Disallow root login remotely? [Y\/n] n<br \/> ... skipping.<br \/><br \/>By default, MySQL comes with a database named 'test' that anyone can<br \/>access.  This is also intended only for testing, and should be removed<br \/>before moving into a production environment.<br \/><br \/>Remove test database and access to it? [Y\/n] n<br \/> ... skipping.<br \/><br \/>Reloading the privilege tables will ensure that all changes made so far<br \/>will take effect immediately.<br \/><br \/>Reload privilege tables now? [Y\/n] Y<br \/> ... Success!<br \/><br \/><br \/><br \/><br \/>All done!  If you've completed all of the above steps, your MySQL<br \/>installation should now be secure.<br \/><br \/>Thanks for using MySQL!<br \/><br \/><br \/>Cleaning up...<\/span><\/pre>\n<\/div>\n<div style=\"text-align: justify;\"><\/div>\n<div style=\"text-align: justify;\">Y con eso hemos instalado MySQL 5.7.x en Fedora 23.<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>1.- Instalar el repositorio oficial de MySQL sudo dnf -y localinstall http:\/\/dev.mysql.com\/get\/mysql57-community-release-fc23-7.noarch.rpm 2.-&nbsp; Actualizar repositorios: sudo dnf -y update Antes que nada, configurar la versi\u00f3n a utilizar en los repositorios de MySQL, para esto ejecutar los siguientes comandos: sudo dnf config-manager &#8211;enable mysql57-community sudo dnf repolist enabled | grep \u00abmysql.*-community.*\u00bb sudo dnf -y update &nbsp;3.- [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,893,891,892,894,60],"tags":[],"class_list":["post-1667","post","type-post","status-publish","format-standard","hentry","category-fedora","category-instalar-mysql-en-fedora-23","category-install-mysql","category-install-mysql5-7-in-fedora-23","category-myql5-7","category-mysql"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=1667"}],"version-history":[{"count":0,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1667\/revisions"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=1667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=1667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=1667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}