Bug #10667 'mysqlshow' client make server crash
Submitted: 16 May 2005 12:11 Modified: 16 May 2005 16:06
Reporter: Disha Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:5.0.5-beta-nt OS:Windows (Windows xp)
Assigned to: CPU Architecture:Any

[16 May 2005 12:11] Disha 
Description:
I have created user with 'select' privileges and try to execute 'mysqlshow' it is crashing server.

How to repeat:
Repro Steps:
	1. execute the following command.
		delimiter //
		Create user 'm'@'localhost'//
		GRANT select ON test01.* TO 'm'@'localhost'//
		flush privileges//
	2. execute the following syntax from command prompt
		mysqlshow -u m -i test01
 
Expected Result: Status of table / tables

Actual Result: Server crash
[16 May 2005 16:06] MySQL Verification Team 
I tested with 5.0.4 and 5.0.6 and I was unable to repeat:

c:\mysql\bin>mysqlshow -u m -i test01
Database: test01
+--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-
--------------------+------------+-------------------+----------+----------------+---------+
| Name   | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         |
Update_time         | Check_time | Collation         | Checksum | Create_options | Comment |
+--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-
--------------------+------------+-------------------+----------+----------------+---------+
| table1 | MyISAM | 10      | Fixed      | 0    | 0              | 0           | 21474836479     | 1024         | 0         |                | 2005-05-16 13:05:53 |
2005-05-16 13:05:53 |            | latin1_swedish_ci |          |                |         |
+--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-
--------------------+------------+-------------------+----------+----------------+---------+

c:\mysql\bin>