MySQL Foundation II

a User Management

1. Create user identified by ' password ';

2. Delete users drop user xxx;

3. Renaming users rename user xxx to xxxx;

4. Modify the current user password setpassword=password (' xxxx ');

5. Modify other user password setpassword for xxx =password (' xxx ');

two Permission System

1. Connection Permissions

2. Action Permissions

Permission level:

1. Global

2. Database

3. Table

4. column

5. Sub-Program

Grant all privileges on * * to ' xxx ' @ '% ' identified by ' xxx ';

Revoke all privileges on * * from ' xxx ' @ ' xxx ' identified by ' xxx ';

three Simple Backup

1. mysqldum–uroot–p libraries that need to be backed up > Backup

2. Source Path / Backup

Four Database Encoding

    1. query mysql supported encodings Span style= "FONT-SIZE:12PX;" >                  Showcharacter set;

2. Enquiry MySQL the encoding used showvariables like ' character% ';

MySQL Foundation II