confirmed - you was right - there was something wrong with my environment ! :(
when I tried with another super user [root] it worked so it's the user it self that has something wrong/missing
The only differences between the two super users accounts are
root has : | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
You can close this bug
thx
-y-
[root@ ~]# pt-slave-find -uroot -pxxxx
Cannot connect to h=10.30.28.84,p=...,u=root
Cannot connect to h=stg-rdb-v3.com,p=...,u=root
Localhost
Version 5.5.28-rel29.1-log
Server ID 513
Uptime 11+20:13:34 (started 2013-03-01T18:55:41)
Replication Is not a slave, has 2 slaves connected, is not read_only
Filters
Binary logging STATEMENT
Slave status
Slave mode STRICT
Auto-increment increment 2, offset 1
InnoDB version 1.1.8-rel29.1
[root@~]# pt-slave-find -udbadmin -pxxxxx
Failed to SHOW GRANTS FOR CURRENT_USER(): DBD::mysql::db selectcol_arrayref failed: [34816] syntax error: syntax error near "CURRENT_USER"
LINE: SHOW GRANTS FOR CURRENT_USER() ^ [for Statement "SHOW GRANTS FOR CURRENT_USER()"] at /usr/bin/pt-slave-find line 2127.
[root@ ~]#
mysql root > SHOW GRANTS FOR CURRENT_USER();
+----------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'CE99A9DAA' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
mysql dbadmin ((none))>> SHOW GRANTS FOR CURRENT_USER();
+------------------------------------------------------------------------------------------------------------------------------------+
| Grants for dbadmin@localhost |
+------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'localhost' IDENTIFIED BY PASSWORD '*FC670BC4C' WITH GRANT OPTION |
+------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
confirmed - you was right - there was something wrong with my environment ! :(
when I tried with another super user [root] it worked so it's the user it self that has something wrong/missing
The only differences between the two super users accounts are
root has : | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
You can close this bug
thx
-y-
[root@ ~]# pt-slave-find -uroot -pxxxx 28.84,p= ...,u=root v3.com, p=...,u= root 01T18:55: 41)
Cannot connect to h=10.30.
Cannot connect to h=stg-rdb-
Localhost
Version 5.5.28-rel29.1-log
Server ID 513
Uptime 11+20:13:34 (started 2013-03-
Replication Is not a slave, has 2 slaves connected, is not read_only
Filters
Binary logging STATEMENT
Slave status
Slave mode STRICT
Auto-increment increment 2, offset 1
InnoDB version 1.1.8-rel29.1
[root@~]# pt-slave-find -udbadmin -pxxxxx
^ [for Statement "SHOW GRANTS FOR CURRENT_USER()"] at /usr/bin/ pt-slave- find line 2127.
Failed to SHOW GRANTS FOR CURRENT_USER(): DBD::mysql::db selectcol_arrayref failed: [34816] syntax error: syntax error near "CURRENT_USER"
LINE: SHOW GRANTS FOR CURRENT_USER()
[root@ ~]#
mysql root > SHOW GRANTS FOR CURRENT_USER(); ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- +
+------
| Grants for root@localhost |
+------
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'CE99A9DAA' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+------
2 rows in set (0.00 sec)
mysql>
mysql dbadmin ((none))>> SHOW GRANTS FOR CURRENT_USER(); ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + @'localhost' IDENTIFIED BY PASSWORD '*FC670BC4C' WITH GRANT OPTION | ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- +
+------
| Grants for dbadmin@localhost |
+------
| GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'
+------
1 row in set (0.00 sec)