{"id":1782,"date":"2015-01-26T12:24:00","date_gmt":"2015-01-26T18:24:00","guid":{"rendered":"http:\/\/linuxitos.com\/main\/instalar-mysql-en-fedora-21\/"},"modified":"2015-01-26T12:24:00","modified_gmt":"2015-01-26T18:24:00","slug":"instalar-mysql-en-fedora-21","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/instalar-mysql-en-fedora-21\/","title":{"rendered":"Instalar MySQL en fedora 21"},"content":{"rendered":"

<\/span>1.- Instalar el repositorio oficial de MySQL<\/p>\n

sudo yum -y localinstall http:\/\/dev.mysql.com\/get\/mysql-community-release-fc21-5.noarch.rpm<\/span><\/pre>\n
2.-  Actualizar repositorios:<\/p>\n
sudo yum -y update<\/span><\/pre>\n
3.- Instalar MySQL<\/p>\n
sudo yum -y install mysql-community-server<\/span><\/pre>\n
4.- Iniciar el servicio de MySQL<\/p>\n
sudo systemctl start mysql.service<\/span><\/pre>\n
5.- Ejecutar Instalaci\u00f3n segura de MySQL para cambiar par\u00e1metros predeterminados.<\/div>\n
sudo \/usr\/bin\/mysql_secure_installation<\/span><\/pre>\n
Al ejecutar este comando obtendr\u00e1n la siguiente salida, y seleccionen a su conveniencia, aqu\u00ed el ejemplo:<\/div>\n
<\/div>\n
NOTE<\/span>:<\/span> <\/span>RUNNING <\/span>ALL <\/span>PARTS <\/span>OF <\/span>THIS<\/span> <\/span>SCRIPT <\/span>IS<\/span> <\/span>RECOMMENDED <\/span>FOR<\/span> <\/span>ALL <\/span>MySQL<\/span><\/span><\/b><\/div>\n
      <\/span>SERVERS <\/span>IN<\/span> <\/span>PRODUCTION <\/span>USE<\/span>!<\/span>  <\/span>PLEASE <\/span>READ<\/span> <\/span>EACH<\/span> <\/span>STEP <\/span>CAREFULLY<\/span>!<\/span><\/span><\/b><\/div>\n
<\/div>\n
In<\/span> <\/span>order <\/span>to<\/span> <\/span>log <\/span>into <\/span>MySQL <\/span>to<\/span> <\/span>secure <\/span>it<\/span>,<\/span> <\/span>we<\/span><\/span>‘ll <\/span>need <\/span>the <\/span>current<\/span><\/span><\/b><\/div>\n
password <\/span>for<\/span> <\/span>the <\/span>root <\/span>user<\/span>.<\/span>  <\/span>If<\/span> <\/span>you<\/span><\/span>‘ve <\/span>just <\/span>installed <\/span>MySQL<\/span>,<\/span> <\/span>and<\/span><\/span><\/b><\/div>\n
you <\/span>haven<\/span><\/span>‘t<\/span> <\/span>set <\/span>the <\/span>root <\/span>password <\/span>yet<\/span>,<\/span> <\/span>the <\/span>password <\/span>will <\/span>be <\/span>blank<\/span>,<\/span><\/span><\/b><\/div>\n
so <\/span>you <\/span>should <\/span>just <\/span>press <\/span>enter <\/span>here<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Enter <\/span>current <\/span>password <\/span>for<\/span> <\/span>root<\/span> <\/span>(<\/span>enter <\/span>for<\/span> <\/span>none<\/span>)<\/span>:<\/span> <\/span><\/span><\/b><\/div>\n
OK<\/span>,<\/span> <\/span>successfully <\/span>used <\/span>password<\/span>,<\/span> <\/span>moving <\/span>on<\/span>.<\/span>.<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Setting <\/span>the <\/span>root <\/span>password <\/span>ensures <\/span>that <\/span>nobody <\/span>can <\/span>log <\/span>into <\/span>the <\/span>MySQL<\/span><\/span><\/b><\/div>\n
root <\/span>user <\/span>without <\/span>the <\/span>proper <\/span>authorisation<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Set <\/span>root <\/span>password<\/span>?<\/span> <\/span>[<\/span>Y<\/span>\/<\/span>n<\/span>]<\/span> <\/span>Y<\/span><\/span><\/b><\/div>\n
New<\/span> <\/span>password<\/span>:<\/span> <\/span><\/span><\/b><\/div>\n
Re<\/span>–<\/span>enter <\/span>new<\/span> <\/span>password<\/span>:<\/span> <\/span><\/span><\/b><\/div>\n
Password <\/span>updated <\/span>successfully<\/span>!<\/span><\/span><\/b><\/div>\n
Reloading <\/span>privilege <\/span>tables<\/span>.<\/span>.<\/span><\/span><\/b><\/div>\n
 <\/span>.<\/span>.<\/span>.<\/span> <\/span>Success<\/span>!<\/span><\/span><\/b><\/div>\n
<\/div>\n
<\/div>\n
By <\/span>default<\/span>,<\/span> <\/span>a<\/span> <\/span>MySQL <\/span>installation <\/span>has <\/span>an <\/span>anonymous <\/span>user<\/span>,<\/span> <\/span>allowing <\/span>anyone<\/span><\/span><\/b><\/div>\n
to<\/span> <\/span>log <\/span>into <\/span>MySQL <\/span>without <\/span>having <\/span>to<\/span> <\/span>have<\/span> <\/span>a<\/span> <\/span>user <\/span>account <\/span>created <\/span>for<\/span><\/span><\/b><\/div>\n
them<\/span>.<\/span>  <\/span>This<\/span> <\/span>is<\/span> <\/span>intended <\/span>only <\/span>for<\/span> <\/span>testing<\/span>,<\/span> <\/span>and<\/span> <\/span>to<\/span> <\/span>make<\/span> <\/span>the <\/span>installation<\/span><\/span><\/b><\/div>\n
go<\/span> <\/span>a<\/span> <\/span>bit <\/span>smoother<\/span>.<\/span>  <\/span>You <\/span>should <\/span>remove <\/span>them <\/span>before <\/span>moving <\/span>into<\/span> <\/span>a<\/span><\/span><\/b><\/div>\n
production <\/span>environment<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Remove <\/span>anonymous <\/span>users<\/span>?<\/span> <\/span>[<\/span>Y<\/span>\/<\/span>n<\/span>]<\/span> <\/span>Y<\/span><\/span><\/b><\/div>\n
 <\/span>.<\/span>.<\/span>.<\/span> <\/span>Success<\/span>!<\/span><\/span><\/b><\/div>\n
<\/div>\n
Normally<\/span>,<\/span> <\/span>root <\/span>should <\/span>only <\/span>be <\/span>allowed <\/span>to<\/span> <\/span>connect <\/span>from<\/span> <\/span>‘localhost’<\/span>.<\/span>  <\/span>This<\/span><\/span><\/b><\/div>\n
ensures <\/span>that <\/span>someone <\/span>cannot <\/span>guess <\/span>at<\/span> <\/span>the <\/span>root <\/span>password <\/span>from <\/span>the <\/span>network<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Disallow <\/span>root <\/span>login <\/span>remotely<\/span>?<\/span> <\/span>[<\/span>Y<\/span>\/<\/span>n<\/span>]<\/span> <\/span>Y<\/span><\/span><\/b><\/div>\n
 <\/span>.<\/span>.<\/span>.<\/span> <\/span>Success<\/span>!<\/span><\/span><\/b><\/div>\n
<\/div>\n
By <\/span>default<\/span>,<\/span> <\/span>MySQL <\/span>comes <\/span>with<\/span> <\/span>a<\/span> <\/span>database <\/span>named<\/span> <\/span>‘test’<\/span> <\/span>that <\/span>anyone <\/span>can<\/span><\/span><\/b><\/div>\n
access<\/span>.<\/span>  <\/span>This<\/span> <\/span>is<\/span> <\/span>also <\/span>intended <\/span>only <\/span>for<\/span> <\/span>testing<\/span>,<\/span> <\/span>and<\/span> <\/span>should <\/span>be <\/span>removed<\/span><\/span><\/b><\/div>\n
before <\/span>moving <\/span>into<\/span> <\/span>a<\/span> <\/span>production <\/span>environment<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Remove <\/span>test<\/span> <\/span>database <\/span>and<\/span> <\/span>access <\/span>to<\/span> <\/span>it<\/span>?<\/span> <\/span>[<\/span>Y<\/span>\/<\/span>n<\/span>]<\/span> <\/span>Y<\/span><\/span><\/b><\/div>\n
 <\/span>–<\/span> <\/span>Dropping <\/span>test<\/span> <\/span>database<\/span>.<\/span>.<\/span>.<\/span><\/span><\/b><\/div>\n
 <\/span>.<\/span>.<\/span>.<\/span> <\/span>Success<\/span>!<\/span><\/span><\/b><\/div>\n
 <\/span>–<\/span> <\/span>Removing <\/span>privileges <\/span>on <\/span>test<\/span> <\/span>database<\/span>.<\/span>.<\/span>.<\/span><\/span><\/b><\/div>\n
 <\/span>.<\/span>.<\/span>.<\/span> <\/span>Success<\/span>!<\/span><\/span><\/b><\/div>\n
<\/div>\n
Reloading <\/span>the <\/span>privilege <\/span>tables <\/span>will <\/span>ensure <\/span>that <\/span>all <\/span>changes <\/span>made <\/span>so <\/span>far<\/span><\/span><\/b><\/div>\n
will <\/span>take <\/span>effect <\/span>immediately<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Reload <\/span>privilege <\/span>tables <\/span>now<\/span>?<\/span> <\/span>[<\/span>Y<\/span>\/<\/span>n<\/span>]<\/span> <\/span>Y<\/span><\/span><\/b><\/div>\n
 <\/span>.<\/span>.<\/span>.<\/span> <\/span>Success<\/span>!<\/span><\/span><\/b><\/div>\n
<\/div>\n
Cleaning <\/span>up<\/span>.<\/span>.<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
All <\/span>done<\/span>!<\/span>  <\/span>If<\/span> <\/span>you<\/span><\/span>‘ve <\/span>completed <\/span>all <\/span>of <\/span>the <\/span>above <\/span>steps<\/span>,<\/span> <\/span>your <\/span>MySQL<\/span><\/span><\/b><\/div>\n
installation <\/span>should <\/span>now <\/span>be <\/span>secure<\/span>.<\/span><\/span><\/b><\/div>\n
<\/div>\n
Thanks <\/span>for<\/span> <\/span>using <\/span>MySQL<\/span>!<\/span><\/span><\/b><\/div>\n
<\/div>\n
6.-  Cambiar contrase\u00f1a de un usuario<\/div>\n
mysqladmin -u root password [tu_contrae\u00f1a_aqu\u00ed]
 
## ejemplo ##
mysqladmin -u root password minuevacontrasenia<\/span><\/pre>\n
7.- Iniciar modo MySQL desde consola<\/div>\n
mysql -u root -p
 
## o podr\u00edan usar ##
mysql -h localhost -u root -p<\/span><\/pre>\n
Espero y les haya servido.<\/p>\n
Estos pasos es una resumen de instalaci\u00f3n de MySQL en Fedora 21, de la siguiente fuente: http:\/\/www.if-not-true-then-false.com\/2010\/install-mysql-on-fedora-centos-red-hat-rhel\/<\/p>\n","protected":false},"excerpt":{"rendered":"
1.- Instalar el repositorio oficial de MySQL sudo yum -y localinstall http:\/\/dev.mysql.com\/get\/mysql-community-release-fc21-5.noarch.rpm 2.-  Actualizar repositorios: sudo yum -y update 3.- Instalar MySQL sudo yum -y install mysql-community-server 4.- Iniciar el servicio de MySQL sudo systemctl start mysql.service 5.- Ejecutar Instalaci\u00f3n segura de MySQL para cambiar par\u00e1metros predeterminados. sudo \/usr\/bin\/mysql_secure_installation Al ejecutar este comando obtendr\u00e1n la […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1236,1273,891,60,1061],"tags":[],"class_list":["post-1782","post","type-post","status-publish","format-standard","hentry","category-fedora-21","category-instalar-mysql-en-fedora-21","category-install-mysql","category-mysql","category-repositorios"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1782","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=1782"}],"version-history":[{"count":0,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1782\/revisions"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=1782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=1782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=1782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}