By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Can't access MySQL RDS

0

I can connect to my MySQL RDS with the same user name and password for my windows server, but can't access it from my Amazon Linux 2023.

I ran "show processlist" on MySQL workbench, it showing the user from Amazon Linux 2023 "unauthenticated user" even I entered the same user name, password and host.

Enter image description here

Topics
ComputeDatabase
Tags
Amazon LinuxMySQL
Language
English
RKing
asked a year ago238 views
1 Answer
0

When a user connects to MySQL but has not yet sent their credentials, MySQL does not know the actual user's name yet. Until the user sends its login credentials, MySQL returns "unauthenticated user" in the running process's user column

It would be interesting if you tried again with and without TLS from the client in case it’s this. This could be the cause.

What error message do you get when trying to connect?

profile picture
EXPERT
Gary Mclean
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content