#!/usr/bin/perl
# cpanel - killmysqluserprivs                     Copyright(c) 2010 cPanel, Inc.
#                                                           All Rights Reserved.
# copyright@cpanel.net                                         http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited

BEGIN { unshift @INC, '/usr/local/cpanel'; }

use strict;
use Cpanel::Mysql              ();
use Cpanel::Config::LoadCpConf ();
use Cpanel::Config::LoadConfig ();

my $user = @ARGV ? $ARGV[0] : '';

die 'No user specified' if !$user;

my $cpconf = Cpanel::Config::LoadCpConf::loadcpconf();

my %DBOWNERS;
Cpanel::Config::LoadConfig::loadConfig( '/etc/dbowners', \%DBOWNERS, ': ' );
%DBOWNERS = reverse %DBOWNERS;

my $cpuser =  $DBOWNERS{$user};

$Cpanel::user = $cpuser;
my $mysql  = Cpanel::Mysql->new();
my @users = $mysql->listusers();

foreach my $db_user ( $user, @users) {
    $mysql->sendmysql("DELETE FROM user WHERE user='$db_user';");
    $mysql->sendmysql("DELETE FROM db WHERE user='$db_user';");
    $mysql->sendmysql("DELETE FROM tables_priv WHERE user='$db_user';");
    $mysql->sendmysql("DELETE FROM columns_priv WHERE user='$db_user';");
    if ( $cpconf->{'mysql-version'} >= 5 ) {
        $mysql->sendmysql("DELETE FROM procs_priv WHERE user='$db_user';");
    }
}

$mysql->sendmysql("FLUSH PRIVILEGES;");