1

I can't connect to my server when I use a remote IP address.

Localhost is working fine.

Some info:

OS: Ubuntu 16.04

Database: MariaDB

Port 3306 is open

User has remote (%) access.

I've changed bind-address in 50-server.conf to bind-address = 0.0.0.0 and I tried commenting it out. none of them worked. Also tried putting bind-address = 0.0.0.0in my.conf under a [mysqld] grouptag. After every change I restarted Mysql and tried to connect with this command mrsql -u root -h xxx.xxx.xxx.xxx -p. It works fine for localhost, but does not work when I try my servers IP.

How do I solve this problem?

Improve this question
3
  • Have you checked iptables and selinux? Commented Apr 12, 2017 at 13:27
  • How do I do that? Commented Apr 12, 2017 at 13:47
  • What does netstat -lnp | grep mysql show after MySQL starts? Commented Apr 12, 2017 at 15:25

1 Answer 1

Reset to default
-1

Already solved it.

Restarting my server solved the problem.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.