[5.1 Vs 5.5 ] ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in' (using password: YES)

[Vinay Gupta]

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()                    |
+------------------------------------------+-----------------------------------+
| testu...@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