Home / server / Questions / 1015395
In Process
Uday Kiran Reddy
Asked: 2020-05-04 00:13:10 +0800 CST

Mysql not connecting using docker

  • 772

Docker image used: https://hub.docker.com/_/mysql/?tab=description

docker command used: docker run -d -p 3306:3306 -e MYSQL_USER=mysqladmin -e MYSQL_PASSWORD=Notallowed1! -e MYSQL_DATABASE=testdb -e MYSQL_ROOT_PASSWORD=password mysql:latest

with root\password getting this error "Unable to load authentication plugin 'caching_sha2_password'"

With "adminuser\Notallowed1!" Access denied for user 'adminuser'@'192.168.99.1' (using password: YES)

Connection properties: allowPublicKeyRetrieval=true useSSL=false and true both tried

mysql docker

1 Answers

  1. Hello this seems to be a problem with your MySQL client, not the database itself.

    Can you tell us which client you are using?

    Have you tried to connect with another SQL client? (PHP/ mariadb-client, DataGrip etc?)

    • 0