The REVOKE command should do most of the job for you, which is removing the
privileges for a specific user. See the manual for more.

However, the user remains defined in the "user" table (while having no
privileges), until one with access, deletes him/her manually.

HTH,
Lian

> -----Original Message-----
> From: Stephan Samuel [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 5:39 PM
> To: [EMAIL PROTECTED]
> Subject: Delete user/no access to mysql db
>
>
> Hi.
>
> I'm using MySQL on my web host. I'm a dba of the db's that I create, but I
> have no access to the mysql db. I can create users (GRANT USAGE
> ON my_db ...
> works), but I don't know how to get rid of them.
>
> I searched the manual, and the only reference to removing users
> that I could
> find was deleting records from mysql.user. Is there another way?
>
> Thanks,
> Stephan Samuel
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to