List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 15 1999 11:31pm
Subject:SHOW TABLES in 3.23
View as plain text  
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.23Sasha Pachev16 Jul