[cobalt-users] MySQL User list needs flushing

["John D. Gorena" <Support@xxxxxxxxxxxxxxxxxxx>]

OK, the 'mysqladmin' command works with the root password.  I created a few
users that I want to delete but I can't seem to make it work.  I'm sure that I
am missing something easy.  Apparently, I wrote down the password wrong for one
user and created another.  I want to delete all of the users and just add one to
the database.

In my example:

I created a database user which I will call MYUSER1 for MYDATABASE

telnet-prompt] mysql MYDATABASE
mysql > grant usage on MYDATABASE.* to MYUSER1@localhost;
 mysql > grant select,insert,delete,update on MYDATABASE.* to MYUSER1@localhost;

 mysql > exit;
 $ mysqladmin -u MYUSER1 password "UNKNOWNPASSWORD"

How do I show all users in the database?

How do I remove these users?

What do I need to do to clean this mess up?



--
John D. Gorena
PC and Internet Marketing Consultant
http://www.JMG-Enterprises.com
Office: 972-315-0496
Fax: 972-315-3104