Comment 9 for bug 1136834

Revision history for this message
yvonne (mysql-girl) wrote :

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)