grant `create routine`,`alter routine`,`event`,`trigger` on db.*. fix

[jingshanglu]

What problem does this PR solve?

Parser related fix for https://github.com/pingcap/tidb/issues/27955 (create routine, alter routine,event,triggerneed to be on DB level).

What is changed and how it works?

In MySQL, CREATE ROUTINE,ALTER ROUTINE,EVENT,TRIGGER these privileges shoule be on DB level, and TRIGGER should be in table level,the Parser definition AllDBPrivs did not include CREATE ROUTINE,ALTER ROUTINE,EVENT,TRIGGER and AllTablePrivs did not include TRIGGER which made TiDB fail when checking it.

Check List

Tests

• Manual test (add detailed scripts or steps below)
  • Built TiDB with go.mod change replace github.com/pingcap/parser => ../parser to build tidb-server with the locally changed parser repository
  • Tested this

    CREATE USER u;
    CREATE DATABASE t;
    USE t;
    CREATE TABLE t1 (a int);
    GRANT create routine  ON t.* TO u;
    GRANT alter routine ON t.* TO u;
    GRANT event ON t.* TO u;
    GRANT trigger ON t.* TO u;
    GRANT trigger ON t.t1 TO u;

    successful

Code changes

• Has exported variable/fields change: AllDBPrivs , AllTablePrivs

[ti-chi-bot]

[REVIEW NOTIFICATION]

This pull request has not been approved.

To complete the pull request process, please ask the reviewers in the list to review by filling /cc @reviewer in the comment. After your PR has acquired the required number of LGTMs, you can assign this pull request to the committer in the list by filling /assign @committer in the comment to help you merge this pull request.

The full list of commands accepted by this bot can be found here.

Reviewer can indicate their review by submitting an approval review. Reviewer can cancel approval by submitting a request changes review.