Hello.
> I am ssh'd int the box, so I am localhost, I am root, and it just does not > want to let me remove access privs, in this case, all I have is select Recreate grants for the 'root'@'localhost' user manually. For this purpose restart server with --skip-grant-tables command line options and modify the grant tables. See: http://dev.mysql.com/doc/mysql/en/resetting-permissions.html http://dev.mysql.com/doc/mysql/en/privileges.html > Mysql 4.0.18-standard Your version of MySQL is rather old, I recommend you to upgrade to the latest release (use 4.1.14 or 4.0.25). Scott Haneda <[EMAIL PROTECTED]> wrote: > Mysql 4.0.18-standard > > revoke all on *.* from 'deleteatanytime'@'localhost'; > > mysql> revoke all on *.* from 'deleteatanytime'@'localhost'; > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > mysql> revoke all on *.* from [EMAIL PROTECTED]; > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > I am ssh'd int the box, so I am localhost, I am root, and it just does not > want to let me remove access privs, in this case, all I have is select > privs. For the longest time I just delete the user and recreate the > permissions, but I would like to figure out how to make this work. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]