Server MySQL Authorized connection user

The following is the entire process of creating a write to delete, to a drop:

1: Create a database

Create Database it1110;

2: Enter this database

Use it1110;

3: Create a data table

Create Table Teac (

Id int,

Name varchar (30)

);

4: Write Information

Insert into TEAC values (1, ' Jack ');

5: Query Information

Select * from TEAC;

6: Modify Information

Update Teac set name= ' Rose ';

Select * from TEAC;

7: Delete information from table

Delete from Teac;

Select * from TEAC;

8: Delete Table

Drop table Teac; -DDL

9 Deleting a database

Use MySQL;

Drop database it1110;

13.7.3, Data Control language (create a user in this machine and authorize him)

dcl– authorized.

What permissions does Grant set .........

Invoke Revoke Authorization

Grant all on *. WJ ' @ '% ' with GRANT option;

Grant All On * *--Set all resources

To-give

' WJ ' @ '% '--WJ can be logged on on all machines

With--at the same time

Grant option; -WJ This user can also delegate permissions to others

Create a user file login password is 1234

granting permissions

Take a look

Modifications will be used on all machines Chen can log in to the specified IP address of the machine

View inside information

Delete haha this line of information

on other computers that access the server MySQL

Open cmd input:-uchen–p1234–h192.168.1.100

Remote operation is possible after login is successful.

Server MySQL Authorized connection user