Re: Cannot connect to remote mysql.

[Roel Van de Paar]

Hi Tom,

I can see that you are new to this.

1) http://screencast.com/t/adoUbfiekTik
Actually, what this shows, is that you are trying to enter bash shell commands in a mysql shell. Please search 'bash shell' in Google for more information about what the bash shell is.
It also shows you already have a mysql client available, though I am not sure how you invoked it.
2) http://screencast.com/t/ll15fWMcU4
Aha, very good. Again this does not show a failing connection but rather trying to enter bash shell commands (which should have gone behind the "#" and without the "$" in front of them) at the command line. No need to use my commands anymore as we have established you have a mysql client ready.

Screenshots 3+4+5 help too.

Please execute at the # bash prompt (i.e. "-bash-3.2#");

mysql --no-defaults -u<remoteUsername> -P<remotePassword> -h<remoteIP> -P<remotePort>

Replacing the <...> variables with the correct values. For example, <remoteport> is likely to be 3306 looking at the pastie's. Thus for example (fake values);

mysql --no-defaults -uroot -Prootpass -h172.10.10.10 -P3306