| f00li5h | i can connect with mysql from a shell on that box, but not from mysql on another box via an ssh tunnel |
| kimseong | f00li5h: why localhost? |
| f00li5h | kimseong: pardon? |
| kimseong | the errror message got me@localhost, which means it is connecting to local mysql server |
| CuriosCat | 'me@localhost' or 'me'@'localhost' ? |
| f00li5h | CuriosCat: the first one kimseong: the ssh tunnel makes the remote host's port look like a port on the local host |
| MBzle | kimseong, nothing in mind? |
| kimseong | MBzle: don;t think there is anything else you can do |
| CuriosCat | f00li5h: 'me@localhost' refers to a useraccount that's literally 'me@localhost' the @ gets treated as part of the username, not as a username-hostname separator |
| kimseong | CuriosCat: but the error always return the client host |
| f00li5h | CuriosCat: so 'me@localhost' is really me@localhost@localhost?' s/'$// |
| kimseong | f00li5h: can you confirm the error message again |
| f00li5h | ERROR 1045: Access denied for user: 'me@localhost' (Using password: NO|YES) |
| CuriosCat | ERROR 1045 (28000): Access denied for user 'me'@'localhost' (using password: NO) that's what it SHOULD look like |
| X13 | NO|YES? That's helpful. |
| CuriosCat | your error doesn't appear to be mentioning the connecting host at all |
| f00li5h | X13: as in "it does not maptter" |
| CuriosCat | that doesn't look like a standard mysql error what version? |
| f00li5h | mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386) CuriosCat: i'm not making it up |
| CuriosCat | <shrug> Dunno. Your mysql client isn't acting the same way as mine, but I'm running 5.0.27 |
| _syphilis_ | 'x@y' is normal for 4.0 |
| f00li5h | am i right in assuming that the API only changes between major releases? |
| CuriosCat | OK, then I dunno. f00li5h: In theory :) |
| kimseong | i had 'x'@'y' on mysql cli 4.0.27, but don;t have that (28000) |
| _syphilis_ | kim: probably depends on server rather than client.. |
| kimseong | oh, i see |
| CuriosCat | the (28000) is probably a 5.x thing, kimseong. (I deliberately used an invalid username to reproduce the error) |
| kimseong | i tried on 5.0 too |
| CuriosCat | generally, when you're connecting on localhost, hopefully mysqld and mysql are in sync, version-wise :) |
| f00li5h | it seems to be 0.1 or so difference between the clients onn the 2 hosts |
| CuriosCat | Which is newer, client or server? a newer client should at the very least be backwards-compatible. |