Skip to Main Content

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

User_LG3GYJan 17 2022

I am new to Oracle Cloud and not an expert on MySql, I have built my first Arm-based Ampere A1. I was successfully able to install Apache web server. I tried to do a yum install for MySQL.
I can start and stop mysqld
/usr/sbin/mysqld (mysqld 8.0.27) starting as process 2408
I can confirm that port 3306 starts
However when I try to login into MySQL itself
$mysql -u root
I get the following error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).
I have tried the following
I have updated /etc/my.cnf with a password for root
Turned off SELinux
sudo mysqld --skip-grant-tables --skip-networking
Any help is greatly appreciated!

Post Details
Added on Jan 17 2022