I'm trying to set up a connection from one e2c (amazon) instance towards another e2c instance.
I've:
- Adapted the security group as follows: MYSQL/Aurora TCP 3306 client-ip/32 (with client-ip the literal ip address of my client instance
- bind-address is set to 0.0.0.0 in my.cnf (that already took me some effort to find out)
- iptables isn't running (or is at least not holding back anything)
- I've rebooted the server after changing the security group
- see list below for content of my user database
- mysqld is restarted
- after each grant I did flush privileges (on the server)
This command does work:
root@server:~# mysql -u root -p
this doesn't:
ubuntu@client:~$ mysql -u root -p -h server-ip mysql (with the literal ip address)
with following exception:
ERROR 1045 (28000): Access denied for user 'root'@'ec2-client-ip.eu-west-1.compute.amazonaws.com' (using password: YES)
output of:
select Host, User from user;
+---------------------------------------------------+------------------+
| Host | User |
+---------------------------------------------------+------------------+
| % | name |
| 127.0.0.1 | root |
| client-ip.ec2.internal | root |
| client-ip | phpmyadmin |
| client-ip | root |
| ::1 | root |
| ec2-client-ip.eu-west-1.compute.amazonaws.com | phpmyadmin |
| ec2-client-ip.eu-west-1.compute.amazonaws.com | root |
| ip-172-30-0-191 | root |
| localhost | debian-sys-maint |
| localhost | liftoff |
| localhost | phpmyadmin |
| localhost | root |
+---------------------------------------------------+------------------+
Don't worry, this isn't production (at all) just some playing around...
I really don't know what I'm overlooking here, maybe it's just something stupid, I have no idea why this isn't working.
telnet server-ip 3306
gives me the gibberish you would expect from a mysql server;
any help is greatly appreciated...
both instances are ubuntu, one Ubuntu 14.04.5 LTS (with mysql server 5.6) the client is Ubuntu 16.04.1 LTS with mysql client 5.7; I really hope this is not the problem...