Re: [cobalt-users] MySQL User list needs flushing

[Peter Batenburg <peter@xxxxxxxxxx>]

Try this at the mysql prompt: flush privileges;
To list all users: use mysql;
select * from user;

Maybe its a good idea to install phpMyAdmin?
Its far more easy to delete and insert users than the command prompt. And 
all webbased.

At 23:29 24-4-2001 -0500, you wrote:
> 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?