How to connect external mysql server in docker container

Question

I built a Django app in a docker container. And run it on a server with ip 192.168.1.13. And I set the Django settings.py to connect mysql server at 192.168.1.6. It is an external independent server. But when I run the container, it always say access denied for user [email protected]. How can Django connect to the docker host ip but not the defined server ip?

Any body can help me to solve this problem? Many thanks.

There are two server.

Server A is 192.168.1.13. There is a django docker container running on it.

Server B is 192.168.1.6. It is a mysql server.

And I want django container to connect server B. But it reported can't connect to its host server.

dukebody · Accepted Answer · 2014-11-25 08:59:13Z

1

It looks like you granted access to your user accessing only through the localhost. Try the following on your MySQL server:

GRANT ALL PRIVILEGES ON * . * TO 'xxx'@'192.168.1.13';

Please note that the IP address after the @ above refers to the address the MySQL client is connecting from (your Django container), not the address of the MySQL server.

edited Nov 25, 2014 at 8:59

answered Nov 24, 2014 at 9:33

dukebody

7,2053 gold badges38 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

morphinewan Over a year ago

Thank you for your reply. But I don't think your suggestion will work. Because 192.168.1.13 is my docker host. It is not the mysql server indeed. MySQL server IP is 192.168.1.6. I set it in the settings.py, but django instance try to connect 192.168.1.13 instead. That is my problem.

dukebody Over a year ago

The IP address specified in the answer refers to the host the user is connecting from, not the one it connects to. Have you tested my command?

morphinewan Over a year ago

Thank you. I am so stupid. I misunderstood your suggestion. Your answer is correct. My problem is resolved. Thank you again.

Kenny Over a year ago

Can you use wild cards for the IP? Say I want everyone on 192.168.*.* to be able to connect.

DDecoene Over a year ago

Yes, you use a % sign as a wildcard. like: user_name@'192.168.%'

Collectives™ on Stack Overflow

How to connect external mysql server in docker container

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related