N98\Util\Console\Helper\DatabaseHelper::mysqlUserHasPrivilege PHP Method

    public function mysqlUserHasPrivilege($privilege)
    {
        $statement = $this->getConnection()->query('SHOW GRANTS');
        $result = $statement->fetchAll(PDO::FETCH_COLUMN);
        foreach ($result as $row) {
            if (preg_match('/^GRANT(.*)' . strtoupper($privilege) . '/', $row) || preg_match('/^GRANT(.*)ALL/', $row)) {
                return true;
            }
        }
        return false;
    }