1

How to connect to Amazon RDS MySQL instance while preventing MITM attack

view story
linux-howto

http://serverfault.com – I have an Amazon RDS instance running MySQL. I've created a user account, and I've configured MySQL to require the use of SSL for all logins to that account. I want the MySQL client to be able to authenticate the server, to ensure that man-in-the-middle attacks cannot occur. The MySQL command-line client has an option for this, namely --ssl-verify-server-cert. However, when I try it, I get the following, uninformative, error message: ERROR 2026 (HY000): SSL connection error So this command works fine: mysql --host $RDS_host --user $username \ --password=$password \ --ssl-ca mys (HowTos)

grtyyu's picture
Submitted by grtyyu on 10/10/2012

Stories similar to How to connect to Amazon RDS MySQL instance while preventing MITM attack

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled)

I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql server is 5.5.25)..

~> mysql -u <user> -p --ssl=1 --ssl-cert=client.cert --ssl-key=client.key --ssl-ca=ca.cert Enter password: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):

I have enabled SSL on MySQL 5.1.52 on CentOS 6.0 using the following guide: http://www.madirish.net/node/244

I have followed the instructions correctly but I am running into the following error when I try to connect from the client server:

[root@mta mysql]# mysql -u ssluser -h 10.178.234.142 -p ssldb Enter password: ERROR 2026 (HY000): SSL connection error

I have been doing some research and h

The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:

mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection.

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

I receive the following error when trying to connect to mySql through phpmyadin:

MySQL said:

1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.

You do not put username and password in config.inc.php, this is only if you use $cfg['Servers'][$i]['auth_type'] = 'config';but this means that the user is directly logged in and only when you have created the user in mysql first. This method is not recommened. just comment out user and password and then create the user IN MYSQL.

hi I am trying to connect mysql server running on amazon linux instance but did not succeeded yet .

Scenario : i installed mysql server in amazon's ec2 instance .

I've been trying to figure out why I keep getting this error when I try to connect to the MySQL server with the following commands.

$~ mysql -u username -h SQLserver -p Enter password: ERROR 1045 (28000): Access denied for user 'username'@'myIP' (using password: YES)

I've done the following: Port is open in the firewall other wise I wouldn't get the error it'd just timeout. MySQL server not run

Can't start MySQL 39 weeks 4 hours ago

Hi,

I have install MySQL serve in Fedora 16 32 bi distro that I have on my pc, but I can't start MySQL from command line. Can you please help?