{"id":1468,"date":"2017-11-21T13:51:00","date_gmt":"2017-11-21T19:51:00","guid":{"rendered":"http:\/\/linuxitos.com\/main\/instalar-mysql-5-7-en-fedora-27\/"},"modified":"2017-11-21T13:51:00","modified_gmt":"2017-11-21T19:51:00","slug":"instalar-mysql-5-7-en-fedora-27","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/instalar-mysql-5-7-en-fedora-27\/","title":{"rendered":"Instalar MySQL 5.7 en Fedora 27"},"content":{"rendered":"
\n
<\/div>\n
\n
<\/a><\/div>\n


<\/span>Con la llegada de Fedora 27, ahora toca actualizar todos nuestros paquetes a las versiones m\u00e1s recientes. Esto no obligatorio obviamente, pero si es recomendable hacerlo.<\/span><\/div>\n


<\/span><\/div>\n
La instalaci\u00f3n de MySQL, y MySQL Workbench requiere del repositorio oficial de MySQL para permitir la instalaci\u00f3n. Adem\u00e1s, en los primeros meses usualmente no est\u00e1 disponible Workbench, sin embargo siempre podemos utilizar DBeaver<\/a>, una alternativa para Workbench.<\/span><\/div>\n

<\/span><\/div>\n
1.- <\/span>Primero que nada descargar el repositorio<\/span><\/div>\n
https:\/\/dev.mysql.com\/get\/mysql57-community-release-fc27-10.noarch.rpm<\/a><\/span><\/div>\n

<\/span><\/div>\n
2.- Instalarlo<\/span><\/div>\n
$ sudo dnf install mysql57-community-release-fc27-10.noarch.rpm<\/span><\/span><\/pre>\n
3.- Habilitar MySQL 5.7.x ya que por default viene activada la opci\u00f3n 5.6.x<\/span><\/div>\n
$ sudo dnf config-manager --enable mysql57-community<\/code><\/b><\/span><\/pre>\n
$ sudo dnf repolist enabled | grep \"mysql.*-community.*\"<\/code><\/b><\/span><\/pre>\n
$ sudo dnf config-manager --disablerepo mysql56-community-source<\/code><\/b><\/span><\/pre>\n
$ sudo dnf config-manager --disablerepo <\/code><\/b>mysql56-community<\/span><\/code><\/span><\/span><\/pre>\n
$ sudo dnf -y update<\/span><\/span><\/pre>\n

<\/code><\/b><\/span><\/div>\n
4.- Instalar MySQL<\/span><\/div>\n
sudo dnf -y install mysql-community-server<\/span><\/pre>\n
5.- Iniciar MySQL<\/span><\/div>\n
sudo systemctl start mysqld.service<\/span><\/pre>\n
6.- 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:<\/span>

<\/span><\/p>\n
sudo grep 'temporary password' \/var\/log\/mysqld.log<\/span><\/pre>\n

<\/span>Y les mostrar\u00e1 algo as\u00ed:<\/span>

<\/span><\/p>\n
2016-06-21T23:50:02.789634Z 1 [Note] A temporary password is generated for root@localhost: ej2VXy(eNN.p<\/span><\/span><\/pre>\n<\/div>\n

<\/span>7.- Iniciar configuraci\u00f3n de MySQL:<\/span>
<\/span><\/p>\n
\n
$ mysql_secure_installation<\/code><\/b><\/span><\/pre>\n

<\/code><\/b><\/span><\/div>\n<\/div>\n
y lanzar\u00e1 en la terminal lo siguiente:<\/span>

<\/span><\/div>\n
\n
\n
Set root password? [Y\/n] Y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y\/n] Y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y\/n] n
 ... skipping.

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y\/n] n
 ... skipping.

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y\/n] Y
 ... Success!




All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!


Cleaning up...<\/pre>\n<\/div>\n<\/div>\n

<\/span>Ya han finalizado la instalaci\u00f3n de mysql: <\/span>para probarlo ingresar en la terminal:<\/span>
<\/span><\/p>\n
\n
mysql -u root -p<\/span><\/code><\/span><\/span><\/pre>\n<\/div>\n<\/div>\n
Les pedir\u00e1 la contrase\u00f1a, al ingresarla les mostrar\u00e1 lo siguiente:<\/span>

<\/span><\/p>\n
\n
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 11
Server version: 5.7.13 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and\/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and\/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> <\/span><\/span><\/pre>\n<\/div>\n

<\/span>Si les muestra ese resultado, entonces todo ha ido perfecto.<\/span>

<\/span>Debido a que en los repositorios oficiales de MySQL a\u00fan no est\u00e1 disponible MySQL Workbench, no se puede instalar.<\/span>
Pero cuando ya est\u00e1 disponible, la instalaci\u00f3n es la siguiente:<\/span>

<\/span>Listar todas las utilerias disponibles para instalar:<\/span>
<\/span><\/p>\n
\n
sudo dnf --disablerepo=* --enablerepo='mysql*-community*' list available<\/span><\/code><\/span><\/span><\/pre>\n

<\/code><\/b><\/span><\/div>\n<\/div>\n
Y les mostrar\u00e1 una lista de todos los elementos disponibles, lo que hay que hacer es:<\/span>
<\/span><\/p>\n
\n
sudo dnf install mysql-workbench-community<\/code><\/b><\/span><\/pre>\n

<\/code><\/b><\/span><\/div>\n<\/div>\n
Gracias por Visitar…<\/span><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Con la llegada de Fedora 27, ahora toca actualizar todos nuestros paquetes a las versiones m\u00e1s recientes. Esto no obligatorio obviamente, pero si es recomendable hacerlo. La instalaci\u00f3n de MySQL, y MySQL Workbench requiere del repositorio oficial de MySQL para permitir la instalaci\u00f3n. Adem\u00e1s, en los primeros meses usualmente no est\u00e1 disponible Workbench, sin embargo […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[125,124,60,123],"tags":[],"class_list":["post-1468","post","type-post","status-publish","format-standard","hentry","category-instalar-mysql-en-fedora-27","category-install-mysql-on-fedora","category-mysql","category-mysql-5-7"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1468","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=1468"}],"version-history":[{"count":0,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1468\/revisions"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=1468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=1468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=1468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}