Hello,
I have installed a new instance with the "Oracle Linux Developer" image. This installs MySQL Community edition 8.0. I used the Oracle provided Stack to install everything.
Normally the root login does not have a password. Although this install seems to have a password since I cannot log in with the password blank.
The documentation here does not have a solution. I have searched everywhere else too.
https://docs.oracle.com/en-us/iaas/mysql-database/doc/connecting-db-system.html#GUID-591AFFED-1181-4DBC-837C-55BD3E726E6A
I have tried to login against all hosts in the /etc/hosts i.e. the localhost/127.0.0.1 and others as well. But no joy.
[db-shop2]$ mysql -h 127.0.0.1 -uroot -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Thank you.