![\"CentOS](\"http:\/\/dbahire.com\/wp-content\/uploads\/2014\/07\/centos7_mysql561.png\")
<\/p>\n<\/p>\n
La \u00faltima versi\u00f3n de Red Hat Enterprise Linux<\/a>, una de las distribuciones de Linux m\u00e1s populares y respetadas en el mercado de servidores, se public\u00f3 en junio de 2014<\/a>, seguido por los lanzamientos de CentOS 7<\/a> y Oracle Linux<\/a> en julio del mismo a\u00f1o.<\/p>\n Hay cambios muy interesantes para administradores de bases de datos en estas nuevas versiones, de las cuales me gustar\u00eda destacar el hecho de que el instalador oficial ahora selecciona XFS<\/a> como el sistema de archivos por defecto, sustituyendo a ext4 como el formato preferido para almacenamiento local. Red Hat EL7 tambi\u00e9n incluye Btrfs<\/a> como tech preview<\/em>.<\/p>\n Respecto a paqueter\u00eda<\/a>, el cambio con mayor impacto es, en mi opini\u00f3n, la actualizaci\u00f3n de las versiones de MySQL y PostgreSQL, en verdad necesitadas de un upgrade, ya que la anterior versi\u00f3n de Red Hat, 6.5, todav\u00eda utilizava versiones con 5 a\u00f1os de edad de ambos SGBBDD, los cuales se encontraban fuera de su ciclo de vida de soporte. La mayor sorpresa es que Red Hat ha optado por elegir MariaDB 5.5, y no Oracle, como el proveedor por defecto de MySQL (o compatible). Esto tiene la hilarante consecuencia de que Oracle Linux est\u00e1 distribuyendo en realidad la versi\u00f3n de su competidor, MariaDB a trav\u00e9s de sus repositories<\/a>, con el objetivo de ser 100% compatible. La diferencia, claro est\u00e1, es que Oracle ofrece la \u00faltima versi\u00f3n de MySQL en sus repositorios de yum<\/a> y, por lo tanto, est\u00e1 disponible para su instalaci\u00f3n en todas las distribuciones compatibles con Red Hat.<\/p>\n En este tutorial os mostraremos c\u00f3mo instalar MySQL 5.6 en CentOS 7, \u00fatil para aquellos que prefieran desplegar la \u00faltima versi\u00f3n GA de MySQL<\/a>. 5.6 introduce una gran cantidad de mejoras sobre MySQL 5.5<\/a>, y dado que Red Hat EL7 tiene un ciclo de soporte de al menos 10 a\u00f1os<\/a>, es posible que se vuelva muy anticuada en el futuro. Vamos a mostrar el proceso en CentOS 7, pero \u00e9ste ser\u00e1 id\u00e9ntico en RHEL 7 y, hasta cierto punto, en otras distribuciones basadas en yum como las \u00faltimas versiones de Fedora y Amazon Linux.<\/p>\n Por favor, tenga en cuenta que el siguiente tutorial supone que no hay una versi\u00f3n previamente instalada de MySQL o MariaDB. Puede utilizar el siguiente comando: El primer paso es configurar el repositori de MySQL de Oracle; para ello, nos dirigimos a la web de mysql.com<\/a>, pulse en “Downloads<\/a>“, luego en “Yum repository<\/a>” y finalmente en “Red Hat Enterprise Linux 7”. En el momento de escribir estas l\u00edneas, est\u00e1 versi\u00f3n del respositorio se encuentra todav\u00eda en beta, pero no tuve problemas para instalarlo en diversas conbinaciones de software y hardware. Seleccione “Download<\/a>” y le aparecer\u00e1 la opci\u00f3n de acceder o crear una cuenta de Oracle. Podemos omitir este paso y simplemente copiar el enlace en la parte inferior que dice “No thanks , just start my download”. Esto nos proporcionar\u00e1 la direcci\u00f3n del rpm para auto-configurar los repositorios de la versi\u00f3n Community del servidor de MySQL<\/a>.<\/p>\n Ahora, si ejecuta en un terminal:<\/p>\n Podemos comprobar que los respositories est\u00e1n efectivamente activos ejecutando:<\/p>\n Acabamos de realizar la configuraci\u00f3n (s\u00f3lo es necesario hacerlo una vez) que nos permitir\u00e1 instalar y mantener actualizada nuestra instalaci\u00f3n de MySQL de manera f\u00e1cil y sencilla.<\/p>\n El siguiente paso es instalar realmente los paquetes del servidor. Para ello, escribimos:<\/p>\n Como podr\u00e1 apreciar, los paquetes del servidor Community hacen referencia a la \u00faltima versi\u00f3n de MySQL 5.6. Durante el proceso de instalaci\u00f3n, s\u00f3lo dos interrupciones se producir\u00e1n (aparte de la petici\u00f3n de contrase\u00f1a de sudo), una para la confirmaci\u00f3n de los cambios, y otra para la importaci\u00f3n de la clave de releases de los ingenieros de Oracle<\/a> en su sistema, que podremos aceptar sin problemas si su fingerprint conincide con el siguiente: La instalaci\u00f3n ya se ha completado, ahora s\u00f3lo tenemos que ejecutarlo y probarlo. Recuerde que Red Hat Enterprise Linux 7 reemplaza la gesti\u00f3n de servicios por Puede comprobar que ha iniciado correctamente haciendo:<\/p>\n Y conectarse desde localhost haciendo:<\/p>\n Recuerda tambi\u00e9n activar el autoinicio en el arranque, ya que es algo que querr\u00e1s en la mayor\u00eda de los casos (esto tambi\u00e9n ha cambiado comparado con CentOS 6):<\/p>\n Puede comprobar que se ha activado correctamente con el comando ‘status’ mostrado anteriormente; deber\u00eda mostrarse ahora como “enabled” (activado).<\/p>\n Como buen administrador, los siguientes pasos son configurar las cuentas de usuario y securizar el servicio de mysql, pero eso est\u00e1 fuera de los objetivos de este tutorial.<\/p>\n Gracias a la instalaci\u00f3n mediante respositorios, sus paquetes ahora pueden ser actualizados f\u00e1cilmente tan s\u00f3lo usando yum.<\/p>\n Para una documentaci\u00f3n m\u00e1s detallada, puede revisar la documentaci\u00f3n oficial<\/a>. Los ingenieros de Oracle publicaron tambi\u00e9n una interestante historia sobr el proceso de pruebas de sus paquetes<\/a>.<\/p>\n Espero que este tutorial haya sido de utilidad.<\/p>\n","protected":false},"excerpt":{"rendered":" Un poco de historia La \u00faltima versi\u00f3n de Red Hat Enterprise Linux, una de las distribuciones de Linux m\u00e1s populares y respetadas en el mercado de servidores, se public\u00f3 en junio de 2014, seguido por los lanzamientos de CentOS 7<\/p>\n","protected":false},"author":1,"featured_media":186,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[86,82,87,88,84,83,79,80,89,457,90,91,92,78,93,94,81,95,96,97,98],"class_list":["post-276","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql-es","tag-5-6-es","tag-amazon-linux","tag-centos-es","tag-centos7-es","tag-epel","tag-fedora","tag-instalacion","tag-instalar","tag-mariadb-es","tag-mysql-es","tag-mysql-5-6-es","tag-oracle-linux-es","tag-red-hat-es","tag-red-hat-7","tag-redhat-es","tag-redhat7-es","tag-repositorio","tag-rhel-es","tag-rhel7-es","tag-rpm-es","tag-yum-es"],"_links":{"self":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/posts\/276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/comments?post=276"}],"version-history":[{"count":9,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/posts\/276\/revisions"}],"predecessor-version":[{"id":366,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/posts\/276\/revisions\/366"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/media\/186"}],"wp:attachment":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/media?parent=276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/categories?post=276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/tags?post=276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Prerequisitos<\/h2>\n
rpm -qa | grep -i mysql<\/code> para comprobar paquentes de MySQL que est\u00e9n instalados con anterioridad, y borrarlos con el comando yum remove<\/code>.<\/p>\nTutorial<\/h2>\n
\r\n$ sudo yum install http:\/\/dev.mysql.com\/get\/mysql-community-release-el7-5.noarch.rpm\r\n[sudo] password for training:\r\nLoaded plugins: fastestmirror\r\nmysql-community-release-el7-5.noarch.rpm | 6.0 kB 00:00:00 \r\nExamining \/var\/tmp\/yum-root-uI5SBL\/mysql-community-release-el7-5.noarch.rpm: mysql-community-release-el7-5.noarch\r\nMarking \/var\/tmp\/yum-root-uI5SBL\/mysql-community-release-el7-5.noarch.rpm to be installed\r\n\r\nResolving Dependencies\r\n\r\n--> Running transaction check\r\n---> Package mysql-community-release.noarch 0:el7-5 will be installed\r\n--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n==============================================================================================================================\r\nPackage Arch Version Repository Size\r\n==============================================================================================================================\r\nInstalling:\r\nmysql-community-release noarch el7-5 \/mysql-community-release-el7-5.noarch 4.3 k\r\n\r\nTransaction Summary\r\n==============================================================================================================================\r\nInstall 1 Package\r\n\r\nTotal size: 4.3 k\r\nInstalled size: 4.3 k\r\nIs this ok [y\/d\/N]: y\r\nDownloading packages:\r\nRunning transaction check\r\nRunning transaction test\r\nTransaction test succeeded\r\nRunning transaction\r\n Installing : mysql-community-release-el7-5.noarch 1\/1\r\n Verifying : mysql-community-release-el7-5.noarch 1\/1\r\n\r\nInstalled:\r\n mysql-community-release.noarch 0:el7-5 \r\n\r\nComplete!<\/pre>\n
\r\n$ sudo yum repolist enabled | grep \"mysql.*-community.*\"\r\n[sudo] password for training:\r\nmysql-connectors-community\/x86_64 MySQL Connectors Community 9\r\nmysql-tools-community\/x86_64 MySQL Tools Community 4\r\nmysql56-community\/x86_64 MySQL 5.6 Community Server 49\r\n<\/pre>\n
\r\n$ sudo yum install mysql-community-server\r\nLoaded plugins: fastestmirror\r\nLoading mirror speeds from cached hostfile\r\n * base: centos.mirror.xtratelecom.es\r\n * extras: centos.mirror.xtratelecom.es\r\n * updates: centos.mirror.xtratelecom.es\r\nResolving Dependencies\r\n--> Running transaction check\r\n---> Package mysql-community-server.x86_64 0:5.6.19-2.el7 will be installed\r\n--> Processing Dependency: mysql-community-common(x86-64) = 5.6.19-2.el7 for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: mysql-community-client(x86-64) = 5.6.19-2.el7 for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(warnings) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(strict) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(if) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(Sys::Hostname) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(POSIX) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(Getopt::Long) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(File::Temp) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(File::Spec) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(File::Path) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(File::Copy) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(File::Basename) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(Fcntl) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(Data::Dumper) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(DBI) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: net-tools for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: \/usr\/bin\/perl for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.6.19-2.el7.x86_64\r\n--> Running transaction check\r\n---> Package libaio.x86_64 0:0.3.109-12.el7 will be installed\r\n---> Package mysql-community-client.x86_64 0:5.6.19-2.el7 will be installed\r\n--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.19-2.el7 for package: mysql-community-client-5.6.19-2.el7.x86_64\r\n--> Processing Dependency: perl(Exporter) for package: mysql-community-client-5.6.19-2.el7.x86_64\r\n---> Package mysql-community-common.x86_64 0:5.6.19-2.el7 will be installed\r\n---> Package net-tools.x86_64 0:2.0-0.17.20131004git.el7 will be installed\r\n---> Package perl.x86_64 4:5.16.3-283.el7 will be installed\r\n--> Processing Dependency: perl-libs = 4:5.16.3-283.el7 for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-283.el7.x86_64\r\n--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-283.el7.x86_64\r\n---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed\r\n--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64\r\n--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64\r\n---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed\r\n---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed\r\n---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed\r\n---> Package perl-Getopt-Long.noarch 0:2.40-2.el7 will be installed\r\n--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-2.el7.noarch\r\n--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-2.el7.noarch\r\n---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed\r\n--> Running transaction check\r\n---> Package mariadb-libs.x86_64 1:5.5.37-1.el7_0 will be obsoleted\r\n---> Package mysql-community-libs.x86_64 0:5.6.19-2.el7 will be obsoleting\r\n---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed\r\n---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed\r\n---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed\r\n---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed\r\n--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch\r\n--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch\r\n--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch\r\n--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch\r\n---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed\r\n--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch\r\n--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch\r\n---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed\r\n--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch\r\n--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch\r\n---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed\r\n---> Package perl-Socket.x86_64 0:2.010-3.el7 will be installed\r\n---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed\r\n---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed\r\n---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed\r\n---> Package perl-constant.noarch 0:1.27-2.el7 will be installed\r\n---> Package perl-libs.x86_64 4:5.16.3-283.el7 will be installed\r\n---> Package perl-macros.x86_64 4:5.16.3-283.el7 will be installed\r\n---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed\r\n---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed\r\n--> Running transaction check\r\n---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed\r\n---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed\r\n--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch\r\n--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch\r\n---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed\r\n---> Package perl-Pod-Escapes.noarch 1:1.04-283.el7 will be installed\r\n---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed\r\n--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch\r\n--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch\r\n---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed\r\n--> Running transaction check\r\n---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed\r\n---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed\r\n---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed\r\n---> Package perl-parent.noarch 1:0.225-244.el7 will be installed\r\n--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n==============================================================================================================================\r\n Package Arch Version Repository Size\r\n==============================================================================================================================\r\nInstalling:\r\n mysql-community-libs x86_64 5.6.19-2.el7 mysql56-community 2.0 M\r\n replacing mariadb-libs.x86_64 1:5.5.37-1.el7_0\r\n mysql-community-server x86_64 5.6.19-2.el7 mysql56-community 57 M\r\nInstalling for dependencies:\r\n libaio x86_64 0.3.109-12.el7 base 24 k\r\n mysql-community-client x86_64 5.6.19-2.el7 mysql56-community 19 M\r\n mysql-community-common x86_64 5.6.19-2.el7 mysql56-community 247 k\r\n net-tools x86_64 2.0-0.17.20131004git.el7 base 304 k\r\n perl x86_64 4:5.16.3-283.el7 base 8.0 M\r\n perl-Carp noarch 1.26-244.el7 base 19 k\r\n perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k\r\n perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k\r\n perl-DBI x86_64 1.627-4.el7 base 802 k\r\n perl-Data-Dumper x86_64 2.145-3.el7 base 47 k\r\n perl-Encode x86_64 2.51-7.el7 base 1.5 M\r\n perl-Exporter noarch 5.68-3.el7 base 28 k\r\n perl-File-Path noarch 2.09-2.el7 base 26 k\r\n perl-File-Temp noarch 0.23.01-3.el7 base 56 k\r\n perl-Filter x86_64 1.49-3.el7 base 76 k\r\n perl-Getopt-Long noarch 2.40-2.el7 base 56 k\r\n perl-HTTP-Tiny noarch 0.033-3.el7 base 38 k\r\n perl-IO-Compress noarch 2.061-2.el7 base 260 k\r\n perl-Net-Daemon noarch 0.48-5.el7 base 51 k\r\n perl-PathTools x86_64 3.40-5.el7 base 82 k\r\n perl-PlRPC noarch 0.2020-14.el7 base 36 k\r\n perl-Pod-Escapes noarch 1:1.04-283.el7 base 49 k\r\n perl-Pod-Perldoc noarch 3.20-4.el7 base 87 k\r\n perl-Pod-Simple noarch 1:3.28-4.el7 base 216 k\r\n perl-Pod-Usage noarch 1.63-3.el7 base 27 k\r\n perl-Scalar-List-Utils x86_64 1.27-248.el7 base 36 k\r\n perl-Socket x86_64 2.010-3.el7 base 49 k\r\n perl-Storable x86_64 2.45-3.el7 base 77 k\r\n perl-Text-ParseWords noarch 3.29-4.el7 base 14 k\r\n perl-Time-Local noarch 1.2300-2.el7 base 24 k\r\n perl-constant noarch 1.27-2.el7 base 19 k\r\n perl-libs x86_64 4:5.16.3-283.el7 base 686 k\r\n perl-macros x86_64 4:5.16.3-283.el7 base 42 k\r\n perl-parent noarch 1:0.225-244.el7 base 12 k\r\n perl-podlators noarch 2.5.1-3.el7 base 112 k\r\n perl-threads x86_64 1.87-4.el7 base 49 k\r\n perl-threads-shared x86_64 1.43-6.el7 base 39 k\r\n\r\nTransaction Summary\r\n==============================================================================================================================\r\nInstall 2 Packages (+37 Dependent packages)\r\n\r\nTotal download size: 91 M\r\nIs this ok [y\/d\/N]: y\r\nDownloading packages:\r\nwarning: \/var\/cache\/yum\/x86_64\/7\/mysql56-community\/packages\/mysql-community-common-5.6.19-2.el7.x86_64.rpm: V3 DSA\/SHA1 Signature, key ID 5072e1f5: NOKEY\r\nPublic key for mysql-community-common-5.6.19-2.el7.x86_64.rpm is not installed\r\n(1\/39): mysql-community-common-5.6.19-2.el7.x86_64.rpm | 247 kB 00:00:01 \r\n(2\/39): libaio-0.3.109-12.el7.x86_64.rpm | 24 kB 00:00:03 \r\n(3\/39): mysql-community-libs-5.6.19-2.el7.x86_64.rpm | 2.0 MB 00:00:05 \r\n(4\/39): perl-Carp-1.26-244.el7.noarch.rpm | 19 kB 00:00:02 \r\n(5\/39): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:01 \r\n(6\/39): net-tools-2.0-0.17.20131004git.el7.x86_64.rpm | 304 kB 00:00:04 \r\n(7\/39): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:01 \r\n(8\/39): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:01 \r\n(9\/39): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:03 \r\n(10\/39): perl-Exporter-5.68-3.el7.noarch.rpm | 28 kB 00:00:00 \r\n(11\/39): perl-File-Path-2.09-2.el7.noarch.rpm | 26 kB 00:00:00 \r\n(12\/39): perl-File-Temp-0.23.01-3.el7.noarch.rpm | 56 kB 00:00:00 \r\n(13\/39): perl-Filter-1.49-3.el7.x86_64.rpm | 76 kB 00:00:00 \r\n(14\/39): perl-Getopt-Long-2.40-2.el7.noarch.rpm | 56 kB 00:00:00 \r\n(15\/39): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm | 38 kB 00:00:00 \r\n(16\/39): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:01 \r\n(17\/39): perl-Encode-2.51-7.el7.x86_64.rpm | 1.5 MB 00:00:08 \r\n(18\/39): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:03 \r\n(19\/39): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00 \r\n(20\/39): perl-Pod-Escapes-1.04-283.el7.noarch.rpm | 49 kB 00:00:00 \r\n(21\/39): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm | 87 kB 00:00:01 \r\n(22\/39): perl-Pod-Simple-3.28-4.el7.noarch.rpm | 216 kB 00:00:02 \r\n(23\/39): perl-Pod-Usage-1.63-3.el7.noarch.rpm | 27 kB 00:00:00 \r\n(24\/39): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm | 36 kB 00:00:00 \r\n(25\/39): perl-Socket-2.010-3.el7.x86_64.rpm | 49 kB 00:00:00 \r\n(26\/39): perl-Storable-2.45-3.el7.x86_64.rpm | 77 kB 00:00:00 \r\n(27\/39): perl-Text-ParseWords-3.29-4.el7.noarch.rpm | 14 kB 00:00:00 \r\n(28\/39): perl-Time-Local-1.2300-2.el7.noarch.rpm | 24 kB 00:00:00 \r\n(29\/39): perl-constant-1.27-2.el7.noarch.rpm | 19 kB 00:00:00 \r\n(30\/39): perl-PathTools-3.40-5.el7.x86_64.rpm | 82 kB 00:00:12 \r\n(31\/39): perl-libs-5.16.3-283.el7.x86_64.rpm | 686 kB 00:00:03 \r\n(32\/39): perl-parent-0.225-244.el7.noarch.rpm | 12 kB 00:00:00 \r\n(33\/39): perl-podlators-2.5.1-3.el7.noarch.rpm | 112 kB 00:00:00 \r\n(34\/39): perl-threads-1.87-4.el7.x86_64.rpm | 49 kB 00:00:00 \r\n(35\/39): perl-threads-shared-1.43-6.el7.x86_64.rpm | 39 kB 00:00:00 \r\n(36\/39): perl-macros-5.16.3-283.el7.x86_64.rpm | 42 kB 00:00:05 \r\n(37\/39): mysql-community-client-5.6.19-2.el7.x86_64.rpm | 19 MB 00:00:57 \r\n(38\/39): perl-5.16.3-283.el7.x86_64.rpm | 8.0 MB 00:01:13 \r\n(39\/39): mysql-community-server-5.6.19-2.el7.x86_64.rpm | 57 MB 00:01:35 \r\n------------------------------------------------------------------------------------------------------------------------------\r\nTotal 915 kB\/s | 91 MB 00:01:41 \r\nRetrieving key from file:\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\nImporting GPG key 0x5072E1F5:\r\n Userid : \"MySQL Release Engineering
a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5<\/code>. Recuerde que, en el caso de procesos automatizados, podemos a\u00f1adir la opci\u00f3n -y<\/code> (decir s\u00ed a todo) a yum, pero quer\u00eda mostrar el proceso completo, as\u00ed como realizar el proceso con buenas pr\u00e1cticas de seguridad.<\/p>\nsystemd<\/code>, por lo que la manera “correcta” de iniciar el servicio de mysql es:<\/p>\n\r\n$ sudo systemctl start mysqld<\/code>\r\n<\/pre>\n
\r\n$ sudo systemctl status mysqld\r\nmysqld.service - MySQL Community Server\r\n Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; disabled)\r\n Active: active (running) since Sun 2014-07-27 11:20:40 EDT; 10s ago\r\n Process: 10660 ExecStartPost=\/usr\/bin\/mysql-systemd-start post (code=exited, status=0\/SUCCESS)\r\n Process: 10599 ExecStartPre=\/usr\/bin\/mysql-systemd-start pre (code=exited, status=0\/SUCCESS)\r\nMain PID: 10659 (mysqld_safe)\r\n CGroup: \/system.slice\/mysqld.service\r\n \u251c\u250010659 \/bin\/sh \/usr\/bin\/mysqld_safe\r\n \u2514\u250010801 \/usr\/sbin\/mysqld --basedir=\/usr --datadir=\/var\/lib\/mysql --plugin-dir=\/usr\/lib64\/mysql\/plugin --log-erro...\r\n\r\nJul 27 11:20:39 localhost.localdomain mysql-systemd-start[10599]: Support MySQL by buying support\/licenses at http:\/\/sho...com\r\nJul 27 11:20:39 localhost.localdomain mysql-systemd-start[10599]: Note: new default config file not created.\r\nJul 27 11:20:39 localhost.localdomain mysql-systemd-start[10599]: Please make sure your config file is current\r\nJul 27 11:20:39 localhost.localdomain mysql-systemd-start[10599]: WARNING: Default config file \/etc\/my.cnf exists on the...tem\r\nJul 27 11:20:39 localhost.localdomain mysql-systemd-start[10599]: This file will be read by default by the MySQL server\r\nJul 27 11:20:39 localhost.localdomain mysql-systemd-start[10599]: If you do not want to use this, either remove it, or use the\r\nJul 27 11:20:39 localhost.localdomain mysql-systemd-start[10599]: --defaults-file argument to mysqld_safe when starting ...ver\r\nJul 27 11:20:39 localhost.localdomain mysqld_safe[10659]: 140727 11:20:39 mysqld_safe Logging to '\/var\/log\/mysqld.log'.\r\nJul 27 11:20:39 localhost.localdomain mysqld_safe[10659]: 140727 11:20:39 mysqld_safe Starting mysqld daemon with datab...ysql\r\nJul 27 11:20:40 localhost.localdomain systemd[1]: Started MySQL Community Server.\r\nHint: Some lines were ellipsized, use -l to show in full.\r\n<\/pre>\n
\r\n$ mysql -u root\r\nWelcome to the MySQL monitor. Commands end with ; or \\g.\r\nYour MySQL connection id is 2\r\nServer version: 5.6.19 MySQL Community Server (GPL)\r\n\r\nCopyright (c) 2000, 2014, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql>\r\n<\/pre>\n
\r\n$ sudo systemctl enable mysqld.service\r\nln -s '\/usr\/lib\/systemd\/system\/mysqls.service' '\/etc\/systemd\/system\/mysql.service'\r\nln -s '\/usr\/lib\/systemd\/system\/mysqls.service' '\/etc\/systemd\/system\/multi-user.target.wants\/mysqld.service'\r\n<\/pre>\n