Hello! I try to deploy the mysql docker container on my localhost. First, I pull
mysql/mysql-server:latest from docker hub. The mysql docker/docker-server image is generated well. And the container of mysql docker runs without errors. But the problem is the connection fails. With mysql workbench, the ping command is ok and client connection works successfully. But any sql command does not executed at all. Even the ‘use test’ command brings the following error message,
Error Code: 1142 SELECT command denied to user 'root'@'172.17.0.1' for table 'user_variables_by_thread'
I think this is the matter of privilege of mysql docker container. But I have no idea. Any advice, please.