ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'%'

[innovia]

we are struggling to figure this one out

it does not work out of the box - running on OSX

everytime we attempt to start it it fails after intializing the db but when we run it a 2nd time mysql runs becuas ethe DATA_DIR folder already exists

why does it keep failing?

running version 5.6.28 of mysql WITHOUT MODIFICATIONS!

also worth mentioning we see the issue only with docker-compose,

seems like the root user is the one being used to log in to mysql and then attempt to create it while logged in as root fails

[yosifkit]

I assume this is the entrypoint script in the mysql image that is failing.

It is the usual way to modify the root user in sql while being the root user and works fine without docker-compose. What does your yaml have configured for the mysql container?

[Ninir]

@yosifkit I assume @innovia has this kind of configuration:

db:
    image: mysql:5.7.10
    environment:
        MYSQL_ROOT_PASSWORD: root
        MYSQL_DATABASE: mydb
        MYSQL_USER: root
        MYSQL_PASSWORD: root
    ports:
        - 3306:3306

It is also failing for me, but running docker-compose up again makes it. This seems logical as we try to create another root user.

[jlaswell]

@Ninir I'm seeing the same for a fresh docker-compose up on Ubuntu 14.04 for the :5.6 tag, and it also works after re-running another docker-compose up. It only seems to fail any time after rming the container, so it seems to be limited to initial creation.

[yosifkit]

@Ninir, the entrypoint script would fail to work if you set MYSQL_USER to root; specifically line #75 will fail to create the second user 'root'@'%' since it will already exist in the users table from above. If you want to use root as your user, you only need to set MYSQL_ROOT_PASSWORD.

[Ninir]

@yosifkit I know, was just Reproducing @innovia s case :)

[ababushkin]

Anyone found a solution to this problem yet? I've had to switch to MariaDB for the time being.

[Ninir]

@ababushkin One solution was suggested, which is about only setting the MYSQL_ROOT_PASSWORD env var. Are you having another issues?

[ababushkin]

@Ninir sorry I didn't realise that was the suggested solution - I skimmed past @yosifkit post :)

Trying that worked for me.

[yosifkit]

As far as I can tell, the original issue seems solved and has helped others. Closing.

[karthik-aiyer-fujixerox]

@yosifkit I encountered the same problem and tried the suggested solution but doesn't seem to be working for me.
Running attached docker file with following command still gives me the error mentioned in attached docker_log.txt

Command:
docker build --build-arg http_proxy=<value> --build-arg https_proxy=<value> -f mySQL_Dockerfile -t mysql .

docker_log.txt
mySQL_Dockerfile.txt

[karthik-aiyer-fujixerox]

Turns out this solution doesn't work on the "mysql:latest" image. It works fine on "mysql:5.7" image.

[ltangvald]

That is very odd. They are just two different tags for the same image. Both your mysql:latest and mysql:5.7 are updated?