Shulou(Shulou.com)06/01 Report--

The following mainly brings you how to use mysql data control language, I hope these contents can bring you practical use, this is also my editor how to use mysql data control language this article's main purpose. All right, don't talk too much nonsense, let's just read the following.

User management

Location of user data: all users in mysql are stored in the user table in the system database (mysql)-- no matter which database users are stored here.

The initial contents of the table are as follows:

Create a user:

Form:

Create user 'username' @ 'allowed login address / CVM' identified by 'password'

Description:

The address / CVM allowed to log in is to allow the set location to log in with the set user name and password. Other locations are not allowed.

Secure authentication for mysql requires three pieces of information.

Example:

View the user table in mysql:

Delete the user: drop user 'username' @ 'allowed login address or CVM name'; change the user password

Change your password:

Set password = password ('password')

Change someone else's password (provided you have permission):

Set password for 'username' @ 'allowed login address' = password ('password'); rights management

Permissions: mysql database, everything that can be done in it is assigned to about 30 permissions, each of which is represented by a "word"!

For example:

Select: data can be queried; update: data can be modified; delete: data can be deleted; .

There is a permission name called "all": it means all permissions

You have the following permissions:

Another form of expression (with Chinese description):

Grant permissions:

Form:

Grant permission list on a library. An object to 'user name' @ 'allowed login location' [identified by 'password']

Description:

Permission list, that is, multiple permission nouns are separated from each other by commas, for example: select, insert, update can also be written: all

A library. an object that represents a weight to a "subordinate unit" in a specified database; subordinate units are: table name, view name, stored procedure name; stored function name

There are two special grammars

1. *. *: represents all subordinate units in all databases

2. A library. *: represents all the subordinate units in the specified library

[identified by 'password'] is a part that can be omitted. If it is not omitted, it means to change its password while empowering it.

If the user is not stored, this is actually creating a new user; and his password must be set at this time

Deprivation of authority:

Form:

Revoke permission list on some library. an object from 'user name' @ 'allowed login location'

Its meaning is exactly the same as in grant.

Data control language is a statement used to manage mysql users and their permissions

User management

Location of user data: all users in mysql are stored in the user table in the system database (mysql)-- no matter which database users are stored here.

The initial contents of the table are as follows:

Create a user:

Form:

Create user 'username' @ 'allowed login address / CVM' identified by 'password'

Description:

The address / CVM allowed to log in is to allow the set location to log in with the set user name and password. Other locations are not allowed.

Secure authentication for mysql requires three pieces of information.

Example:

View the user table in mysql:

Delete the user: drop user 'username' @ 'allowed login address or CVM name'; change the user password

Change your password:

Set password = password ('password')

Change someone else's password (provided you have permission):

Set password for 'username' @ 'allowed login address' = password ('password'); rights management

Permissions: mysql database, everything that can be done in it is assigned to about 30 permissions, each of which is represented by a "word"!

For example:

Select: data can be queried; update: data can be modified; delete: data can be deleted; .

There is a permission name called "all": it means all permissions

You have the following permissions:

Another form of expression (with Chinese description):

Grant permissions:

Form:

Grant permission list on a library. An object to 'user name' @ 'allowed login location' [identified by 'password']

Description:

Permission list, that is, multiple permission nouns are separated from each other by commas, for example: select, insert, update can also be written: all

A library. an object that represents a weight to a "subordinate unit" in a specified database; subordinate units are: table name, view name, stored procedure name; stored function name

There are two special grammars

1. *. *: represents all subordinate units in all databases

2. A library. *: represents all the subordinate units in the specified library

[identified by 'password'] is a part that can be omitted. If it is not omitted, it means to change its password while empowering it.

If the user is not stored, this is actually creating a new user; and his password must be set at this time

Deprivation of authority:

Form:

Revoke permission list on some library. an object from 'user name' @ 'allowed login location'

Its meaning is exactly the same as in grant.

For the above about how to use mysql data control language, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.