Original code already have a code for delete user but wrong code:
function deleteDatabase()
{
$rdb = $this->lx_mysql_connect('localhost', $this->main->__var_dbadmin, $this->main->__var_dbpassword);
$rdb->query("drop database {$this->main->dbname};");
$this->log_error_messages(false);
$rdb->query("delete from mysql.user where user = '{$this->main->username}';");
$this->log_error_messages(false);
$rdb->query("flush privileges;");
}
Need modified to:
function deleteDatabase()
{
$rdb = $this->lx_mysql_connect('localhost', $this->main->__var_dbadmin, $this->main->__var_dbpassword);
$rdb->query("drop database {$this->main->dbname};");
$this->log_error_messages(false);
// MR -- fix delete database username
// $rdb->query("delete from mysql.user where user = '{$this->main->username}';");
$rdb->query("drop user '{$this->main->username}'@'%';");
$rdb->query("drop user '{$this->main->username}'@'localhost';");
$this->log_error_messages(false);
$rdb->query("flush privileges;");
}