I have looked around on the internet, and I have looked onto StackOverflow for already existing questions. based on YouTube videos, I have:

• Docker installed, no problem there.
• I pulled down the latest mysql image from DockerHub where I had a Docker account
• I was able to startup MySQL on Docker with no issues (-p 3306:3306)
• I have installed the latest MySQL Workbench 8.0 CE with no issues
• I can connect to the instance of MySQL in Docker with this issue of workbench
• I was able even to import several databases from backup dumps from my original machine.

Now the singular problem is that I am trying to create a new user. I see only 2 Authentication Type (which is nothing I ever saw before), and I have selected the default which is: caching_sha2_password. By the way, the other choice is: SHA256_Password.
Using the default authentication Type ‘caching_sha2_password’ and putting in an Authentication String ‘my_authentication_string’ I cannot create a user.

The error is: Wrong Value for Max Queries: Cannot convert an empty string “” to a valid non-negative integer. Please correct this value and try again.
How can I fix this error in MySQL when it is on a docker container????????

I can go to Administration – Optins File, and I get a messages such as:
Location of MySQL Configuration file (ie: my.cnf) not specified.
This is NOT the issue I am concerned about, but leading back that I cannot create a new user because of the other issues. I will continue to research this issue as well.