Connect to MySQL container from the host using command line

Question

I have started Mysql instance in docker by issuing command docker run -d -p 3306:3306 --name some-mysql -e MYSQL_ROOT_PASSWORD=supersecret some-mysql . But when i am trying to login as root by issuing command mysql -u root -p and giving password superscret . I am getting below provided error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Possible duplicate of error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock — Mebin Joe
– Mebin Joe, Commented Mar 21, 2019 at 5:06

Mostafa Hussein · Accepted Answer · 2019-03-21 13:40:41Z

1

I am assuming that you are executing mysql -u root -p from the host itself not inside the container.

So based on my assumption the container does not have a mysql.sock inside the host itself when you run it, so you need to change the default protocol.

This command will connect through tcp instead of socket

mysql --protocol=tcp -u root -p

edited Mar 21, 2019 at 13:40

answered Mar 21, 2019 at 9:08

Mostafa Hussein

12.2k3 gold badges43 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Connect to MySQL container from the host using command line

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related