Docker mysql ERROR 1396 (HY000): Operation CREATE USER failed for ‘root’@’%’

by

According to this github issue, the problem is setting MYSQL_USER to root. It will fail to create the second user 'root'@'%' since it will already exist in the users table.

Therefore, this can be solved by only setting MYSQL_ROOT_PASSWORD, MYSQL_DATABASE, and MYSQL_PASSWORD in the docker-compose.yml file.

Related Contents:

  1. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  2. How can I initialize a MySQL database with schema in a Docker container?
  3. Connect to mysql in a docker container from the host
  4. Docker-compose check if mysql connection is ready
  5. Setting up MySQL and importing dump within Dockerfile
  6. Import data.sql MySQL Docker Container
  7. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  8. How to connect mysql workbench to running mysql inside docker?
  9. Installing MySQL in Docker fails with error message “Can’t connect to local MySQL server through socket”
  10. Connect to Docker MySQL container from localhost?
  11. Creating a docker mysql container with a prepared database scheme
  12. Fatal error: Can’t open and lock privilege tables: Table storage engine for ‘user’ doesn’t have this option
  13. Can not access mysql docker
  14. How to connect locally hosted MySQL database with the docker container
  15. How to execute MySQL command from the host to container running MySQL server?
  16. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  17. Docker Cannot link to a non running container
  18. Is it possible to install only mysqldump on macOS
  19. Mysql not starting in a docker container on MacOS after docker update
  20. MySQL scripts in docker-entrypoint-initdb are not executed
  21. connecting to a docker-compose mysql container denies access but docker running same image does not
  22. not able to connect to mysql docker from local
  23. Docker – Is There Any Difference Between The Two MySQL Docker Images?
  24. Docker Compose mysql import .sql
  25. increase max_allowed_packet size in mysql docker
  26. docker mysql on different port
  27. Gitlab CI + DinD + MySQL services permission issue
  28. Executing SQL scripts on docker container
  29. How to change the default character set of mysql using docker-compose?
  30. Access to mysql container from other container
  31. How do I restore a dump file from mysqldump?
  32. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  33. What is the error “Every derived table must have its own alias” in MySQL?
  34. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  35. UTF-8: General? Bin? Unicode?
  36. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  37. MySQL date format DD/MM/YYYY select query?
  38. Can’t connect to local MySQL server through socket homebrew
  39. Can you use an alias in the WHERE clause in mysql?
  40. How do you list all triggers in a MySQL database?
  41. How to check if field is null or empty in MySQL?
  42. How to export MySQL database with triggers and procedures?
  43. How to import a CSV file into a MySQL table
  44. mysqldump to a tar.gz
  45. Slave replication stops with Last_SQL_Errno: 1032
  46. Increase InnoDB buffer pool size
  47. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  48. Get only the date in timestamp in mysql
  49. MySQL Long Query Progress Monitoring
  50. Join tables from two different server

Leave a Comment