Created
October 9, 2018 14:02
-
-
Save Braytiner/dd766ff66cab158669c3254da9d9f85f to your computer and use it in GitHub Desktop.
Permitir o acesso externo ao banco de dados mysql em um servidor remoto
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Para permitir o acesso externo ao banco de dados mysql em um servidor remoto, é configurar-lo para acessos externos. | |
1. Acessar o mysql de dentro do servidor e dar as permissões de acesso a partir de qualquer IP. | |
mysql> GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY '[senha]' WITH GRANT OPTION; | |
2. Para finalizar atualizar os privilégios mysql> FLUSH PRIVILEGES; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment