Database create user, drop user, grant user (permission) in terminal

Database create user, drop user, grant user (permission) in terminal

create user "username"@"host" identified by "password";
create user "knowledge"@"localhost" identified by "1234";

drop user "username"@"host";
drop user "knowledge"@"localhost";

grant "command" on "database"."table" to "username"@"host";
grant all on *.* to "knowledge"@"localhost";