How's MySQL gonna ban all the crews except listed in advance?

[magpie]

How's MySQL gonna ban all the crews except those listed in advance? If the team isn't on the list, MySQL won't work it out.

[courtlanda]

MySQL has a camera. GRANT♪ We need to create a new user. rootand give him the right to perform certain operators.

Example of syntax:

GRANT SELECT, INSERT ON *.* TO 'someuser'@'somehost';

In this example, we give the user someuser the right to perform. SELECT and INSERT in all OBD tables, procedures and functions.

There is also an operator to take user rights.

Example of syntax:

REVOKE INSERT ON *.* FROM 'someuser'@'somehost';

In this example, we take the right of someuser to use the operator. INSERT in all OBD tables, procedures and functions.

Details on the syntax of the teams can be read on the official MySQL website:

1. http://dev.mysql.com/doc/refman/5.1/en/grant.html
2. http://dev.mysql.com/doc/refman/5.7/en/revoke.html