Bug #11810 getting error can't find table customer.MYI ownership problem
Submitted: 8 Jul 2005 11:09 Modified: 8 Aug 2005 11:28
Reporter: Paul McArdle Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.7-beta OS:Linux (fedora 3)
Assigned to: CPU Architecture:Any

[8 Jul 2005 11:09] Paul McArdle 
Description:
Something is screwing with the owner of the database files.
I was getting errors from mysql-administrator when I clicked on schemas.
mysqlCLI  check tables couldn't do anything as it couldn't find table. show tables showed them.

How to repeat:
Don't want to. 
Can only say I have 5 users, 
 mysql - no pww, 
 root - pwd, 
 dbd4 - pwd, 
 DBD4 - old pwd,
 '' - pwd ''
mostly MYISAM type 
tables that played up had row format DYNAMIC

have some tables with large indexes but no problems with them.

usually go in as root
mysqld run as mysql

created tables, played around.

Suggested fix:
Investigation showed actual file representations of various tables 'owner' was root.
Manually changing to 'mysql- Mysql Server' fixed this.
[8 Jul 2005 11:28] MySQL Verification Team 
Hello Paul,

Thank you for the report, but we need repeatable test case.

This means we need the set of actions that causes table files creation owned by user root.
What MySQL distribution do you use?
[8 Aug 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".