Re: Cleaning up a messy mysql

2003-09-12 Thread Paul DuBois
At 9:26 PM -0700 9/12/03, Scott Haneda wrote: I have inherited a mysql install, in the user table, there are many usernames and passwords that are not connected to any databases or tables. Looks like someone deleted the databases at one time and neglected to d it right and left ghost users around.

Cleaning up a messy mysql

2003-09-12 Thread Scott Haneda
I have inherited a mysql install, in the user table, there are many usernames and passwords that are not connected to any databases or tables. Looks like someone deleted the databases at one time and neglected to d it right and left ghost users around. Any way to issue some sql that would search t