MySQL-Viewing of user rights and user deletion

give this user all permissions (all) to manipulate all tables in all databases (*. *)
Grant all privileges on * * to ' test1 ' @ ' 192.168.1.196 ';

Create user and authorization, use a statement
Create user Test3 Specify IP and assign permissions Select,delete,update,insert all tables under the shop database
Grant Select,delete,update,insert on shop.* to ' test3 ' @ ' 127.0.0.1 ' identified by ' 000000 ';

View Permissions
Show grants for ' Test ' @ ' 192.168.1.196 ' \g;

Delete User
Drop user ' test3 ' @ ' 127.0.0.1 ';

-----------------------------------------------

MySQL-Viewing of user rights and user deletion