I:\mysql\5.1\5.1.54\mysql-advanced-gpl-5.1.54-win32\bin>mysqld-debug --console --datadir=e:/wrk/bugs/bug59663/data --innodb-log-file-size=53M 110125 0:54:32 [Note] Plugin 'FEDERATED' is disabled. 110125 0:54:32 InnoDB: Initializing buffer pool, size = 8.0M 110125 0:54:32 InnoDB: Completed initialization of buffer pool 110125 0:54:33 InnoDB: Started; log sequence number 0 10229721 110125 0:54:33 [Note] Event Scheduler: Loaded 0 events 110125 0:54:33 [Note] mysqld-debug: ready for connections. Version: '5.1.54-enterprise-gpl-advanced-debug' socket: '' port: 3306 MySQL Enterprise Server - Advanced Edition Debug (GPL) I:\mysql\5.5\5.5.8\mysql-5.5.8-win32\bin>mysql -udc -hlocalhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.54-enterprise-gpl-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select * from information_schema.tables; +---------------+--------------------+---------------------------------------+-------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | +---------------+--------------------+---------------------------------------+-------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------------+ | NULL | information_schema | CHARACTER_SETS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 384 | 0 | 16604160 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=43690 | | | NULL | information_schema | COLLATIONS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 231 | 0 | 16704765 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=72628 | | | NULL | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 195 | 0 | 16691610 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=86037 | | | NULL | information_schema | COLUMNS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=4560 | | | NULL | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2565 | 0 | 16757145 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=6540 | | | NULL | information_schema | ENGINES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 490 | 0 | 16709000 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=34239 | | | NULL | information_schema | EVENTS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=618 | | | NULL | information_schema | FILES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2677 | 0 | 16758020 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=6267 | | | NULL | information_schema | GLOBAL_STATUS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | NULL | information_schema | GLOBAL_VARIABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | NULL | information_schema | KEY_COLUMN_USAGE | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4637 | 0 | 16762755 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=3618 | | | NULL | information_schema | PARTITIONS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=5612 | | | NULL | information_schema | PLUGINS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=13025 | | | NULL | information_schema | PROCESSLIST | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=23899 | | | NULL | information_schema | PROFILING | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 308 | 0 | 16562084 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=54471 | | | NULL | information_schema | REFERENTIAL_CONSTRAINTS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4814 | 0 | 16767162 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=3485 | | | NULL | information_schema | ROUTINES | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=588 | | | NULL | information_schema | SCHEMATA | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3464 | 0 | 16755368 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=4843 | | | NULL | information_schema | SCHEMA_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2179 | 0 | 16767405 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=7699 | | | NULL | information_schema | SESSION_STATUS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | NULL | information_schema | SESSION_VARIABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | NULL | information_schema | STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2679 | 0 | 16770540 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=6262 | | | NULL | information_schema | TABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3545 | 0 | 16760760 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=4732 | | | NULL | information_schema | TABLE_CONSTRAINTS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2504 | 0 | 16749256 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=6700 | | | NULL | information_schema | TABLE_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2372 | 0 | 16748692 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=7073 | | | NULL | information_schema | TRIGGERS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=569 | | | NULL | information_schema | USER_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1986 | 0 | 16759854 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=8447 | | | NULL | information_schema | VIEWS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2011-01-25 00:54:40 | 2011-01-25 00:54:40 | NULL | utf8_general_ci | NULL | max_rows=6932 | | | NULL | testing | table1 | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 18874368 | NULL | 2011-01-25 00:53:23 | NULL | NULL | utf8_general_ci | NULL | | | +---------------+--------------------+---------------------------------------+-------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------------+ 29 rows in set (0.05 sec) mysql> show grants; +--------------------------------------------------------+ | Grants for dc@localhost | +--------------------------------------------------------+ | GRANT USAGE ON *.* TO 'dc'@'localhost' | | GRANT SELECT ON `testing`.`table1` TO 'dc'@'localhost' | | GRANT SELECT ON `testing`.`table2` TO 'dc'@'localhost' | +--------------------------------------------------------+ 3 rows in set (0.00 sec) mysql>