difficulty with access to mysql

Asked

Viewed 167 times

0

I am trying to connect remotely to a mysql in google cloud, but I can’t. in google I created an Ubuntu vm, last version, this is my ip, inserir a descrição da imagem aqui

this dripping normally: inserir a descrição da imagem aqui

I configured the firewall as follows: inserir a descrição da imagem aqui

configured in iptables: inserir a descrição da imagem aqui

I also set up my.cnf: inserir a descrição da imagem aqui

surround the Namp -St command -The localhst, the port is open: inserir a descrição da imagem aqui

I’ve been trying for two days an external connection, but I always have the same mistake: inserir a descrição da imagem aqui

internally, per ssh, connects normally, only external connection q does not work.

  • You need to explain which IP the server will use, otherwise it will only listen in 127.0.0.1, in the file "my.cnf" use the parameter "bind-address", put right after the "port".

  • should I put the internal ip? or the external one, as my external ip is not fixed, which I should put?

  • you need to free up external access on my.cnf. Change line bind-address = 127.0.0.1 to #bind-address = 127.0.0.1

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.