A new bug in mysql (version 5.1.52)?
I have mysql installed on 2 CentOS machines and for both I cannot solve this issue. See red coloured result
mysql> select host, password from mysql.user;
+-----------------------+-------------------------------------------+
| host | password |
+-----------------------+-------------------------------------------+
| localhost | *00E247AC5F9AF26AE0194B41E1E769DEE1429A29 |
| localhost.localdomain | |
| 127.0.0.1 | |
| localhost | |
| localhost.localdomain | |
+-----------------------+-------------------------------------------+
5 rows in set (0.01 sec)
mysql> select password from mysql.user order by host;
+-------------------------------------------+
| password |
+-------------------------------------------+
| |
| *00E247AC5F9AF26AE0194B41E1E769DEE1429A29 |
| |
| |
| |
+-------------------------------------------+
5 rows in set (0.01 sec)
mysql> select password from mysql.user order by host limit 0,5;
+-------------------------------------------+
| password |
+-------------------------------------------+
| |
| *00E247AC5F9AF26AE0194B41E1E769DEE1429A29 |
| |
| |
| |
+-------------------------------------------+
5 rows in set (0.01 sec)
mysql> select password from mysql.user order by host limit 0,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.01 sec)
mysql> select password from mysql.user order by host limit 2,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.01 sec)
mysql> select password from mysql.user order by host limit 3,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.00 sec)
mysql> select password from mysql.user order by host limit 4,1;
+----------+
| password |
+----------+
mysql> select host, password from mysql.user;
+-----------------------+-------------------------------------------+
| host | password |
+-----------------------+-------------------------------------------+
| localhost | *00E247AC5F9AF26AE0194B41E1E769DEE1429A29 |
| localhost.localdomain | |
| 127.0.0.1 | |
| localhost | |
| localhost.localdomain | |
+-----------------------+-------------------------------------------+
5 rows in set (0.01 sec)
mysql> select password from mysql.user order by host;
+-------------------------------------------+
| password |
+-------------------------------------------+
| |
| *00E247AC5F9AF26AE0194B41E1E769DEE1429A29 |
| |
| |
| |
+-------------------------------------------+
5 rows in set (0.01 sec)
mysql> select password from mysql.user order by host limit 0,5;
+-------------------------------------------+
| password |
+-------------------------------------------+
| |
| *00E247AC5F9AF26AE0194B41E1E769DEE1429A29 |
| |
| |
| |
+-------------------------------------------+
5 rows in set (0.01 sec)
mysql> select password from mysql.user order by host limit 0,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.01 sec)
mysql> select password from mysql.user order by host limit 1,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.01 sec)
mysql>
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.01 sec)
mysql>
mysql> select password from mysql.user order by host limit 2,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.01 sec)
mysql> select password from mysql.user order by host limit 3,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.00 sec)
mysql> select password from mysql.user order by host limit 4,1;
+----------+
| password |
+----------+
| |
+----------+
1 row in set (0.00 sec)