I'm setting the mysqladmin passwords like so :
mysqladmin -u root -hec2-50-17-36-83.compute-3.amazonaws.com password my_password
And this returns :
mysqladmin: connect to server at 'ec2-50-17-36-83.compute-3.amazonaws.com' failed error: 'Unknown MySQL server host 'ec2-50-17-36-83.compute-3.amazonaws.com' (1)' Check that mysqld is running on ec2-50-17-36-83.compute-3.amazonaws.com and that the port is 3306. You can check this by doing 'telnet ec2-50-17-36-83.compute-3.amazonaws.com 3306'
How do I check that mysqld is running, and better yet, how do I fire her up?
Thus so far:
I logged into the remote DB server ( an EC2 instance ), and performed this :
skip-networking was already commented out as well as the bind-address. So I uncommented the bind address, and added the IP of my remote server, and restarted mysqld.
That didn't work. So I tried the remote DB server. That didn't work.
On the remote DB server ( EC2 Instance ), the only command for mysqld you can perform is
mysqld with no options. I'm just assuming this is actually appropriately resetting it when I write this because it hangs on the command for a few minutes before proceeding.
netstat -nl | grep :3306 on the remote DB server returns this :
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
Not sure if this is relevent, but /etc/init.d/mysqld does not exist on the remote DB server. But the command does exist in /usr/sbin/mysqld .