Score:0

How to fix connection issue with mariadb in amazon RDS?

cn flag

I have created an AMAZON RDS mariadb database under free tier.

I used a random generated password first but it is not connecting.

So, I click modify and updated the database with new password.

but still, I am getting error as below.

(conn=36) Access denied for user 'root'@'175.101.107.213' (using password: YES)
Current charset is windows-1252. If password has been set using other charset, consider using option 'passwordCharacterEncoding'

enter image description here

But I updated the password multiple times but same issue everytime.

Please suggest how to fix that. I checked the passwordCharacterEncoding option in the dbeaver, it is having an empty value.

Tim avatar
gp flag
Tim
Are you using the same password you defined in the AWS console? Try a password without punctuation or special characters. Try MySql to see if it works any differently. It will most likely be user error wrong as thousands of those databases will be created each day, but exactly what... not sure.
Score:0
cn flag

Are you connecting from an external host?

By default mariadb connection policies are restrictive and they only allow for local connections, unless you specify otherwise. Check your configuration file and look for the following line:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

If you want to listen to external connections you should comment that line out and restart the service.

Also note is not a good idea to connect to your database as root, and in some environments (I don't know specifically for Amazon RDS) root login is also disabled for network connections.

Edit: This can be done from Amazon RDS console by setting the Publicly Accessible property of your instance to Yes:

My DB instance is in a public subnet, and I can't connect to it over the internet from my local computer

Score:0
af flag

Can't comment yet. In addition to simplifying the password (for testing), make sure the username matches what was set for the "Master username" when the RDS instance is created.

For MariaDB on RDS the default is "admin".

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.