MySQL Common operations

1. Initial launch
#mysql

Update mysql.user set authentication_string= ' Newpass ', plugin= ' Mysql_native_password ' where user= ' root ';
Flush privileges;
Exit

$ mysql-u root-p//Local Login
$ mysql-u aloha-p-H IP//remote login

2. User Action

Use MySQL;
Create user ' aloha ' @ ' localhost ' identified by ' Aloha '; Create user

Flush privileges;

Grant all on mysql.user to [email protected]; Authorized

Show grants for [email protected]; View authorizations

Revoke all on mysql.user from [email protected]; Cancel Authorization
Update user set authentication_string= ' 123 ' where user= ' Aloha '; Change Password

Delete from user where user= ' Aloha '; Delete User

drop user [email protected]; Delete User

3.DDL data definition

4.DML Data manipulation

MySQL Common operations