0

This question already has an answer here:

I use DB 'Mysql 14.14 Distrib 5.7.24' and the OS is 'Ubuntu 18.04'

The DB server have local IP : 10.0.211.198

And For The application IP : 10.0.214.198

when I try connect form application server to db I get error in the connection but After I read it I found the mysql client change IP to Application IP as below screen

enter image description here

But when I try connect using telnet its successfully connected.

I try to remove db and reinstall it also try different client to connect and its same result.

Thank you

marked as duplicate by mustaccio, McNets, Mr.Brownstone, Colin 't Hart, Josh Darnell Jan 15 at 21:31

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • @mustaccio its different because I already allow remote access and check it with telnet – vipmaa Jan 11 at 15:40
  • What does telnet have to do with MySQL authentication? – mustaccio Jan 11 at 16:12
  • Nothing just test connectivity telnet 10.0.211.198 3306 – vipmaa Jan 11 at 16:16
  • If "nothing", as you correctly point out, why do you use it to check MySQL authentication success? – mustaccio Jan 11 at 16:40
  • @mustaccio I use it for test connection between servers not the authentication crazydomains.com/help/check-mysql-with-telnet – vipmaa Jan 11 at 20:49
0

I see 2 attempts where 'root' is expected to have a password, then two where it is not. Did someone change things meanwhile?

It is not "normal" to allow root to come in any way other than via "localhost". Did someone GRANT access for root from elsewhere? If not, then should you really be logging in as "root"??

telnet checks the connection. However, that is not in question -- "Access denied" came from the server back to the client, hence the connection succeeded.

0

Thanks for your response, I found the problem in my.conf

I change bind address from 172.0.0.1 to 0.0.0.0 and finally its work

bind-adress= 0.0.0.0

Not the answer you're looking for? Browse other questions tagged or ask your own question.