如何用命令行语句在mysql创建库

mysql 三条创建语句
创建库
create database diary default charset utf8mb4;
创建用户
create user diary@localhost identified by 'diary';
或 create user 'four' @'%' identified by '123456';
授权
grant all on diary.* to diary@localhost with grant option;
或Grant all privileges on test.* to 'test'@'%';