Here is the code responsible for not showing the tables (in
sql/sql_show.cc in function mysql_find_files() )
if (check_grant(thd,TABLE_ACLS,&table_list,1))
continue;
It is aparently intended to not show tables that you have no privileges
for. If you start mysqld with the default privilege setup that allows
any user to connect without a password from localhost, check_grant()
does not think you should see even the tables that you have created.
Commenting out the call to it results in being able to see them fine,
but this is not the best solution :-)
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
| Thread |
|---|
| • SHOW TABLES in 3.23 | Sasha Pachev | 16 Jul |