Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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!

Comments
Post Details
Added on Jan 17 2022
2 comments
1,640 views