1. Enter the container
Docker exec – it [MySQL container name]/bin/Bash
2. Log in to MySQL
mysql -uroot -p
Password: [enter your password] or enter directly
3. Execute the following command:
use MySQL;
4. Authorization
grant all privileges on ** to ‘root’@’%’ identified by ‘yourPassword’;
5. Refresh
Flush privileges;
Similar Posts:
- [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist
- Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449
- ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded
- [Solved] Access denied for user ‘ODBC’@’localhost’ (using password: NO)
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
- MYSQL Login Error: mysqladmin: connect to server at ‘localhost’ failed
- The user specified as a definer (‘root’@’%’) does not exist
- [Solved] MYSQL Install and Login Error: Access denied for user ‘ODBC’@’localhost’ (using password: NO)
- [Solved] OCI runtime exec failed……executable file not found in $PATH”: unknown
- [Solved] OCI runtime exec failed: exec failed: container_linux.go:380: starting container process caused: exec: “/bin/bash”: stat /bin/bash: no such file or directory: unknown