If you deploy Docker containers based on an official imagine, you might want to set a root password for heightened security.

Once within the MySQL server, you can then change the password with the command: ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword'; Where newpassword is the new password to be used.

Access can be denied when access to MySQL is attempted through the root user. Root requires insertion of a password and once that is wrongly entered or is not provided, this issue arises.

Security flaw in MySQL, MariaDB allows access with any password—just keep submitting it The flaw, patched in both databases, leaves some versions wide open to attackers ...