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 MySQLsudo 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