Docker mysql socket connection

docker-compose.yml

version: '3.1'
services:
#  phpmyadmin:
#    image: phpmyadmin/phpmyadmin
#    ports:
#      - 8080:80
#    environment:
#      - "PMA_HOST=mysql"
  mysql:
    image: mysql:5.6
    environment:
      MYSQL_USER: username
      MYSQL_PASSWORD: password
      MYSQL_ROOT_PASSWORD: rootpasword
    volumes:
      - dbdata:/var/lib/mysql
      - /var/run/mysqld/:/var/run/mysqld/
    ports:
      - 3306:3306
  elasticsearch:
    image: elasticsearch
    environment:
      discovery.type: single-node
    ports:
      - 9200:9200
      - 9300:9300
volumes:
    dbdata:

permission.sh

mkdir -p /var/run/mysqld
sudo chmod 0777 /var/run/mysqld -R