sábado, 21 de mayo de 2016

Instalar MySQL 5.7.x en Fedora 23


1.- Instalar el repositorio oficial de MySQL

sudo dnf -y localinstall http://dev.mysql.com/get/mysql57-community-release-fc23-7.noarch.rpm
2.-  Actualizar repositorios:
sudo dnf -y update

Antes que nada, configurar la versión a utilizar en los repositorios de MySQL, para esto ejecutar los siguientes comandos:
sudo dnf config-manager --enable mysql57-community
sudo dnf repolist enabled | grep "mysql.*-community.*"
sudo dnf -y update

 3.- Instalar MySQL



sudo dnf -y install mysql-community-server
4.- Iniciar el servicio de MySQL
sudo systemctl start mysql.service
5.- Antes de proseguir con la configuración de MySQL es necesario buscar la contraseña temporal que se le asigna al servidor con el siguiente comando:
sudo grep 'temporary password' /var/log/mysqld.log
Ahí se mostrará la contraseña, ahora así, ejecutar el comando:

6.-  Configurar MySQL:
mysql_secure_installation

Y continuar con el establecimiento de contraseña de root, eliminar los usuarios anonimos, etc.

Lo habitual de estos comandos:
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...
Fuente

0 comentarios:

Publicar un comentario