{"id":2032,"date":"2018-12-10T21:14:16","date_gmt":"2018-12-11T03:14:16","guid":{"rendered":"http:\/\/linuxitos.com\/main\/?p=2032"},"modified":"2018-12-10T21:14:18","modified_gmt":"2018-12-11T03:14:18","slug":"instalar-mysql-8-0-x-en-fedora-29","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/instalar-mysql-8-0-x-en-fedora-29\/","title":{"rendered":"Instalar MySQL 8.0.X en | Fedora 29"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

\u00c9stos pasos los he probado y verificado en mi propia m\u00e1quina. As\u00ed que cualquier duda que tengan, espero poder ayudarlos.<\/p>\n\n\n\n

Instalaci\u00f3n del repositorio de MySQL<\/h2>\n\n\n\n

Instalaci\u00f3n del repositorio en Fedora 29.<\/p>\n\n\n\n

sudo dnf install -y https:\/\/dev.mysql.com\/get\/mysql80-community-release-fc29-1.noarch.rpm<\/pre>\n\n\n\n
Instalar MySQL 8<\/h2>\n\n\n\n
sudo dnf install mysql-community-server<\/pre>\n\n\n\n
Iniciar MySQL 8<\/h2>\n\n\n\n
systemctl start mysqld.service\n\n## use restart after update\n\nsystemctl enable mysqld.service<\/pre>\n\n\n\n
Obtener la contrase\u00f1a aleatoria generada autom\u00e1ticamente<\/h2>\n\n\n\n
Si solo van a actualizar MySQL, la contrase\u00f1a a utilizar es la anterior que se usaba para root, si es una instalaci\u00f3n nueva, entonces se obtiene de esta manera.
<\/p>\n\n\n\n
grep 'A temporary password is generated for root@localhost' \/var\/log\/mysqld.log |tail -1<\/pre>\n\n\n\n
Y la salida ser\u00e1 parecida a esta:<\/p>\n\n\n\n
2018-01-20T21:11:44.229891Z 1 [Note] A temporary password is generated for root@localhost: -et)QoL4MLid<\/pre>\n\n\n\n
Si por alguna raz\u00f3n no les da ninguna salida el comando, pueden buscar manualmente la contrase\u00f1a, el archivo se encuentra en la ruta\u00a0\u00a0sudo gedit \/var\/log\/mysqld.log<\/p>\n\n\n\n
Instalaci\u00f3n segura de MySQL
<\/h2>\n\n\n\n
Ahora, es necesario realizar las siguientes configuraciones de MySQL:<\/p>\n\n\n\n
  • Cambiar la contrase\u00f1a<\/li>
  • Eliminar usuarios an\u00f3nimos<\/li>
  • Deshabilitar accesos remotos<\/li>
  • Eliminar bases de datos de prueba y sus accesos<\/li>
  • Recargar permisos de usuarios<\/li><\/ul>\n\n\n\n
    Este proceso inicia con el siguiente comando:<\/p>\n\n\n\n
    su -<\/pre>\n\n\n\n
    \/usr\/bin\/mysql_secure_installation<\/pre>\n\n\n\n
    Seguir los pasos del instructivo, as\u00ed como se muestra en la salida de ejemplo siguiente:<\/p>\n\n\n\n
    Securing the MySQL server deployment.\n\nEnter password for user root: \n\nThe existing password for the user account root has expired. Please set a new password.\n\nNew password: \n\nRe-enter new password: \n\nVALIDATE PASSWORD PLUGIN can be used to test passwords\nand improve security. It checks the strength of password\nand allows the users to set only those passwords which are\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?\n\nPress y|Y for Yes, any other key for No: y\n\nThere are three levels of password validation policy:\n\nLOW    Length >= 8\nMEDIUM Length >= 8, numeric, mixed case, and special characters\nSTRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file\n\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0\nUsing existing password for root.\n\nEstimated strength of the password: 100 \nChange the password for root ? ((Press y|Y for Yes, any other key for No) : y\n\nNew password: \n\nRe-enter new password: \n\nEstimated strength of the password: 50 \nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y\nBy default, a MySQL installation has an anonymous user,\nallowing anyone to log into MySQL without having to have\na user account created for them. This is intended only for\ntesting, and to make the installation go a bit smoother.\nYou should remove them before moving into a production\nenvironment.\n\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\n\nNormally, root should only be allowed to connect from\n'localhost'. This ensures that someone cannot guess at\nthe root password from the network.\n\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nBy default, MySQL comes with a database named 'test' that\nanyone can access. This is also intended only for testing,\nand should be removed before moving into a production\nenvironment.\n\n\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\n - Dropping test database...\nSuccess.\n\n - Removing privileges on test database...\nSuccess.\n\nReloading the privilege tables will ensure that all changes\nmade so far will take effect immediately.\n\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nAll done! \n<\/pre>\n\n\n\n
    Conectarse a localhost
    <\/h2>\n\n\n\n
    En mi caso, iniciaremos con root, utilizando la contrase\u00f1a que se haya establecido en los pasos de arriba, y cambiar el tipo de autenticaci\u00f3n de MySQL.
    A partir de la versi\u00f3n 5.7.x se agreg\u00f3 un nuevo m\u00e9todo de autenticaci\u00f3n que se llama\u00a0caching_sha2_password, sin embargo, la configuraci\u00f3n es un poco tediosa en linux para poderla utilizar con MySQL Workbench.<\/p>\n\n\n\n
    mysql -h localhost -u root -p<\/pre>\n\n\n\n
    Esto iniciar\u00e1 el prompt de mysql:<\/p>\n\n\n\n
    Enter password: \nWelcome to the MySQL monitor.  Commands end with ; or g.\nYour MySQL connection id is 8\nServer version: 8.0.4-rc-log MySQL Community Server (GPL)\n\nCopyright (c) 2000, 2018, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\n\nmysql><\/pre>\n\n\n\n
    Cambiar contrase\u00f1a del usuario root y convertirlo a tipo por defecto de autenticaci\u00f3n de mysql:<\/p>\n\n\n\n
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'nueva-o-la-misma-contrase\u00f1a';<\/pre>\n\n\n\n
    Agregar el servicio de MySQL el firewall
    <\/p>\n\n\n\n
    firewall-cmd --permanent --zone=public --add-service=mysql\n\n## \u00f3 ##\n\nfirewall-cmd --permanent --zone=public --add-port=3306\/tcp<\/pre>\n\n\n\n
    Reinicia el servicio de MySQL<\/p>\n\n\n\n
    systemctl restart firewalld.service<\/pre>\n\n\n\n
    Instalaci\u00f3n de MySQL Workbench<\/h2>\n\n\n\n
    sudo dnf --disablerepo=* --enablerepo='mysql*-community*' list available<\/pre>\n\n\n\n
    sudo dnf install mysql-workbench-community<\/pre>\n\n\n\n
    \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
    \u00c9stos pasos los he probado y verificado en mi propia m\u00e1quina. As\u00ed que cualquier duda que tengan, espero poder ayudarlos. Instalaci\u00f3n del repositorio de MySQL Instalaci\u00f3n del repositorio en Fedora 29. sudo dnf install -y https:\/\/dev.mysql.com\/get\/mysql80-community-release-fc29-1.noarch.rpm Instalar MySQL 8 sudo dnf install mysql-community-server Iniciar MySQL 8 systemctl start mysqld.service ## use restart after update systemctl […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1569,929,907],"tags":[1595,1561,1594],"class_list":["post-2032","post","type-post","status-publish","format-standard","hentry","category-fedora-29","category-mysql-server","category-mysql-workbench","tag-dnf","tag-fedora","tag-mysql"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2032","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=2032"}],"version-history":[{"count":2,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2032\/revisions"}],"predecessor-version":[{"id":2035,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2032\/revisions\/2035"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=2032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=2032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=2032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}