Hi,

I am trying to connect two mysql servers with different versions ( 5.1 &
5.5 ) . But in Mysql 5.1 i am facing strange issues.

Below testuser exists in both Mysql Versions :


mysql> select host,user,password from mysql.user where user='testuser';
+-----------------------+------------+-------------------------------------------+
| host | user |
password |
+-----------------------+------------+-------------------------------------------+
| localhost | testuser | *FJHHEU5746DDHDUDYDH66488 |
| %.corp.domain.in | testuser | *FJHHEU5746DDHDUDYDH66488 |
+-----------------------+------------+-------------------------------------------+

and skip_networking is OFF


*Mysql Version : 5.1.58-log*

root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname)
ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in'
(using password: YES)

It connect successfully if i remove -h option because it connects by
localhost then

*Mysql version : 5.5.36-log *

root@Serv2:~# mysql -utestuser -p@8AsnM0! -h $(hostname)
Welcome to the MySQL monitor. Commands end with ; or \g.
Server version: 5.5.36-log MySQL Community Server (GPL)
mysql>

mysql> select user(),current_user();
+------------------------------------------+-----------------------------------+
| user() |
current_user() |
+------------------------------------------+-----------------------------------+
| testuser@Serv2.corp.domain.in | testuser@%.corp.domain.in
|
+------------------------------------------+-----------------------------------+

Is dere some bug in Mysql5.1 or i need to set bind_address parameter in it.

Thanks