I seem to have locked myself out of my database. RH8/4.0.18-standard ... the key user
does not have file/reload/etc access. and no access at all to database mysql..
Is there some way to break this down as system root or is the only solution to delete
the whole thing and re-install it?
--
I have a myisam database on a little Redhat 8 Celeron P3-866 with less than 256MB of
ram. (Schema attached). While response for single table queries is excellent.
(Double table queries are also mostly good.) More real world (ie complex) queries are
glacial in their execution.
My
I've got 2 Redhat 8 machines with 4.0.1 (? latest) database. Machine1 is a P3-750,
Machine2 is a P4-1.6 .. The same database is deployed to both machines using myisam
tables. Query on Machine 1 takes almost 2 min to produce data. Same query on
Machine2 returns in 5 seconds... ? Why? (I